Forum Discussion
Matrix Formatting Ideas
- 2 years ago
Hi,
I think you can achieve something very similar to what you are looking for,
like thisfirst, you need to create 2 measures for that:
1) back color - for the background rows you want to highlight2) 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
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
- Anonymous2 years agoNot applicable
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)
- oritam32102 years agoHelper I
Hi,
I don't think it is possible at the moment- Anonymous2 years agoNot applicable
Hi,
Oh Okay!
Thank you so much