on 10 Apr 2018 21:51:50
It is, for the Reader of a Matrix (often not equal to the designer of the Matrix!) easier to unterstand the Information if special rows (like summation) are formatted individual (bold, different Background colour, italic, etc.). This applies also for the columns!
- Comments (4)
RE: Formatting rows in a Matrix individual
My requirement is similar... I have a matrix that drills down 3 levels of categories per top level date. I would like to highlight the date row so users can easily identify this top level of the drilldown.
Oh, and I'm using Direct Query to a SSAS MD cube so no DMX/MDX in the background.
2020-01-27 <<< Highlight this row
category level 1
category level 2
category level 3
detail 1 Values, Values, Values
detail 2 Values, Values, Values
detail 3 Values, Values, Values
2020-01-26 <<< Highlight this row
category level 1
category level 2
category level 3
detail 1 Values, Values, Values
detail 2 Values, Values, Values
detail 3 Values, Values, Values
2020-01-25 <<< Highlight this row
category level 1
category level 2
category level 3
detail 1 Values, Values, Values
detail 2 Values, Values, Values
detail 3 Values, Values, Values
While we're asking for features, maybe highlight any of the Category rows too!
RE: Formatting rows in a Matrix individual
Completely Agree. This is causing me havoc in PBI for Finance/Accounting reports. Being able to underline each matrix column header individually would be awesome
RE: Formatting rows in a Matrix individual
Yes, outdented rows should have formatting (such as bold, underlining, font size, etc.) so they are more prominent than indented rows.
RE: Formatting rows in a Matrix individual
Absolutely necessary however current weakness of PowerBI. At least level of SAP BW/BO (yet clumsy) ought to be equalled.