The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Dear all,
May I ask your advice for below issue?
I created a slicer with date hierarchy date; however, the slicer show all data of the periods, not only the real data of that field.
For example, data for 2019 I have only Jan, Feb, Mar but slicer show 12 months but actual there is no data of the other months.
Please advise how can I solve the issue but keep the hierarchy Year - Quaterly - Month.
Thanks so much!
Solved! Go to Solution.
Hi @Anonymous
You can filter your slicer with a measure that tests whether data exists in your fact table(s).
This would have the effect of removing items with no corresponding data.
The basic pattern is to create a measure like below, and apply it as a visual level filter on the slicer, filtered to 1.
SlicerFilter = INT ( NOT ISEMPTY ( FactTable ) )
See this article for some examples:
Regards
Owen
Hi @Anonymous
You can filter your slicer with a measure that tests whether data exists in your fact table(s).
This would have the effect of removing items with no corresponding data.
The basic pattern is to create a measure like below, and apply it as a visual level filter on the slicer, filtered to 1.
SlicerFilter = INT ( NOT ISEMPTY ( FactTable ) )
See this article for some examples:
Regards
Owen
Hello
i think i have the same problem, i have a table which is custommade from dates starting today till today+366, and i made a new column in which i wrote only 1's.
the i try to display as a slicer in which i put also the slicer filter to display only values in which the control value is 1, it display all the 2 whole years. if you have any sugestions please let me know. thank you
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
136 | |
106 | |
102 | |
73 | |
59 |
User | Count |
---|---|
266 | |
127 | |
119 | |
100 | |
86 |