Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All,
I have a matrix that it has nested rows. Is it possible to see just the bold numbers and 'hide'(remove) the other values that are corresponding to the nested rows?
Solved! Go to Solution.
For your reference.
M_Sum = IF(HASONEVALUE('Data'[Company]),BLANK(),SUM(Data[Daily Sales ( Through a measure)]))
M_HNV = HASONEVALUE(Data[Company])
@mickey64, this is exactly what I needed. Thank you, very much for the solution!
When you hover on the visual you should see some icons appear in upper right or lower right of the visual. If you click the first one (an up arrow) it will collapse the indented column and only show the bold items. Then, the user can expand using the + icon or the icons that appear when they hover. If you don't want them nested at all, remove that field from the rows of your matrix.
Proud to be a Super User! | |
User | Count |
---|---|
73 | |
70 | |
38 | |
23 | |
23 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |