Matrix Formatting Ideas

[Anonymous]

Hi All,

Kindly let me know how can I highlight specific rows background and make the values in Bold in a matrix visual.

Column 1, Column 2 and Column 3 are separate measures

Results - Just a column in a table

Thanks

[oritam3210 · Accepted solution]

Hi,
I think you can achieve something very similar to what you are looking for,
like this

first, you need to create 2 measures for that:
1) back color - for the background rows you want to highlight 

2) font color - for highlighting the text with the dark background 

see examples

back_color =
VAR selctedVal = SELECTEDVALUE('Dim Date'[MonthYearInt])
RETURN
IF(selctedVal IN {202203,202205,202212}, "GRAY","WHITE")

font_color =
VAR selctedVal = SELECTEDVALUE('Dim Date'[MonthYearInt])
RETURN
IF(selctedVal IN {202203,202205,202212}, "WHITE","BLACK")

second,
you need to define for each column (measure) the condition on "Cell elements"

good luck

[Anonymous]

Hi,

Thank you for sharing the idea. Sure! Let me try this.

How can I highlight the same row headers also? ( Gross Profit, EBITDA and EBITDA Margin)

[oritam3210]

Hi, 
I don't think it is possible at the moment

[Anonymous]

Hi,

Oh Okay! 

Thank you so much