Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
The filter pane shows number of items in each category - is there any way (or any custom visual) to be able to show that in a slicer?
Currently in a slicer you have e.g.:
Apple
Banana
Pear
Grapes
Melon
What I would like to display is e.g.:
Apple (56)
Banana (3)
Pear (13)
Grapes (467)
Melon (1)
Solved! Go to Solution.
Hi @Anonymous,
You can use attribute slicer (Custom Visual) for this purpose as you can see in given screenshort with sample dataset.
Thanks,
Bhavankit Navadiya.
Hi @Anonymous,
You can use attribute slicer (Custom Visual) for this purpose as you can see in given screenshort with sample dataset.
Thanks,
Bhavankit Navadiya.
Thanks @Anonymous - that does most of the job (although I wish it was possible to have the numbers without the bar chart!)
@Anonymous,
You may use a calculated column.
Column = Table1[Column1] & " (" & COUNTROWS ( FILTER ( Table1, Table1[Column1] = EARLIER ( Table1[Column1] ) ) ) & ")"
Thanks @v-chuncz-msft - I want to be able to include it in the slicer itself rather than as a separate column but very useful to know for some other things I am trying.
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |