Forum Discussion
Row Level Shading at higher drill down level
Hi,
I have data in a Matrix table. Right now the rows are just shaded alternately but I would like to shade them at each change in the higher drill down level.
Here is my table below. I need them to shade for each [routeId].
Thanks!
Tristan
The steps are about the same as in my previous reply. You should be able to do something like below using conditional formatting - background color
Please see attached sample pbix.
3 Replies
Hi Anonymous ,
If you're trying to conditionally format the row headers, that feature is not currenly supported. If you're trying apply a background color to Total Weight only and assuming that that Total Weight and two after it are measures, I would just set the style presets to None and apply a background color conditional formatting to Total Weight only and then turn the grids on if I wanted to show the horizontal and vertical lines.
Hi danextian
Thanks for reply. All i am trying to do here is make it easier for viewer. Alternating rows is confusing so I need to group shade. Is it possible to shade the measures and then not shade the next 3, each routeid has all 3 measure as a result so I want to shade the first 3 rows, then not the second 3, shade the third 3 etc etc
Thanks
Tristan
The steps are about the same as in my previous reply. You should be able to do something like below using conditional formatting - background color
Please see attached sample pbix.
