Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I'm using multiple slicers in some of my pages.
Most just work fine (date slicers for example) while others show a lot of entries that have no values for the associated visuals.
Lets say I want to filter sales by clients. I get a list with 100 clients in my source file but only 60 of them actually bought something this month. I can't link them to the sales table while importing to omit empty values unfortunately as they come from flat files.
Excel shows these irrelevant values in a greyed-out color in its slicers or even better, does not show them at all when you select the specific option in the right click menu.
Do you know of a way to get the same behavior in PowerBI? This is counterintuitive to our report users as they click through the different clients / products / categories and just find empty values while months without data dont show up.
Thank you
Try using a page level filter to filter out your sales measure for blanks or zeros perhaps?
Thank you for the suggestion.
Unfortunately, this does not work.
I cant use my measures as page level filters but the original field can be used. When using "is not zero" or "is not blank", nothing changes in the report - even when selcting the filter options where measures clearly dont get any values.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
98 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |