Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
For matrix conditional formatting, can we choose to which Total it will apply ? the options now is Total only but no selection to which total. Is there a trick to do so ?
Because I have format like this :
This it self already bugging me since I don't want the Row total to be coloured (formatted) also, only the Column total on the rightmost.
Then if we expand the month, it will become more 'ugly' ->
Else can I have some advice to make this report more attractive but not hurting my eyes.. 😅
Thanks,
Solved! Go to Solution.
you should be able to use something like
Blue Formatting = IF ( ISINSCOPE ( Calendar[Quarter] ), BLANK(), "#B0D0E2" )
which should leave all columns but the row totals (on the far right, those are row totals) blank. You will need to update the table and field names to match your model.
you should be able to use something like
Blue Formatting = IF ( ISINSCOPE ( Calendar[Quarter] ), BLANK(), "#B0D0E2" )
which should leave all columns but the row totals (on the far right, those are row totals) blank. You will need to update the table and field names to match your model.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |