Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a slicer with Department Name and a waterfall chart with Category and a Headcount.
I want to exclude those Department Name from the slicer which has headcount as 0.
Regards,
HI @akj2784,
Maybe you can drag depart column to page level filter and filter value who equal to zero.(slicer not support visual level filter)
Regards,
Xiaoxin Sheng
That does not help. I want to exclude those department which doesnt have any headcount.
HI @akj2784,
Can you provide some sample data for test?
Regards,
XIaoxin Sheng
I dont see the option to upload pbix file.
Something like this. I want to exclude C from Type slicer as I don't have any data for this type in the fact.
HI @akj2784,
No, current slicer not contains this feature, I'd like to suggest you post this requirement to idea forum.
Regards,
Xiaoxin Sheng
User | Count |
---|---|
98 | |
90 | |
82 | |
70 | |
67 |
User | Count |
---|---|
115 | |
104 | |
101 | |
72 | |
64 |