Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi All,
I am working to include slicers on subtotals rows of Matrix Visluization:
P.S: I have build matrix as a pivot in excel so it has subrows too which contribute to the count of subtotals.
Below is the screenshot. I want to put slicer on yellow highlighted numbers:
Note: I tried to add the slicer on summation column however it filters based on sub rows values also (and I want only on subtotals
Solved! Go to Solution.
Hi @Anonymous ,
I'd like to suggest you unrelated table fields as source of slicer, then write a measure to check current row contents level and compare with selected value.
Measure Totals, The Final Word
Clever Hierarchy Handling in DAX
Regards,
Xiaoxin Sheng
Hi @Anonymous ,
I'd like to suggest you unrelated table fields as source of slicer, then write a measure to check current row contents level and compare with selected value.
Measure Totals, The Final Word
Clever Hierarchy Handling in DAX
Regards,
Xiaoxin Sheng
User | Count |
---|---|
84 | |
82 | |
66 | |
52 | |
46 |
User | Count |
---|---|
100 | |
48 | |
42 | |
39 | |
38 |