Conditional formatting according to the value of the Row in a Matrix

[tutuk28]

Hi everyone! 

I have the following matrix:

With the following fields:

Rows: Order, Name

Columns: Scenary

Values: Total

Is there a possibility that when the "Order" row is 2, 5 or 7 it will show me the "complete row" in bold?

Thanks!

Regards!

[Syndicate_Admin]

Hello. I think this can be for you. In the rows I have stores and in columns months, I wanted you to evaluate the values of each row and generate a conditional formatting. To do this, I made a Rankx that will organize the data (1 the largest, for the example is until June, so 6 the smallest)

this is the measure:

and then you enter and perform the conditional formatting, you choose which according to the field and you put the measure you created of Rankx

finally you have as the table.

[Icey · Accepted solution]

Hi @tutuk28 ,

Based on my test, what you want is not supported in Power BI currently.

Here are some similar ideas you can vote up:

additional font formatting (bold, italic, underline, etc);

Matrix: conditional formatting per row in matrix.

In addition, one workaround is below. Please check:

1. Enter data to create a table with one column containing all the column/measure title you need and then put this column into Columns field.

2. Use SWITCH to create a measure.

Measure =
SWITCH (
    SELECTEDVALUE ( 'Table (2)'[Column1] ),
    "Name", MAX ( 'Table'[Name] ),
    "AC", SUM ( 'Table'[AC] ),
    "LY", SUM ( 'Table'[LY] )
)

3. Create a conditional measure.

Conditional = IF ( MAX ( 'Table'[Order] ) IN { 2, 5, 7 }, "Red", "Blue" )

4. Set conditional formatting.

BTW, .pbix file attached.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@tutuk28 , You can change font color. I doubt you can make it bold.

There is an option for font color under conditional formating

refer

https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...

[Mariusz]

Hi @tutuk28 

Sure, please follow the link below to the video with an example.

https://www.sqlbi.com/articles/applying-color-banding-by-document-number-in-power-bi/

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[tutuk28]

Hi @Mariusz 

The problem is that I need to use an matrix.
And for the array I cannot apply conditional formatting to my Rows values (Order, Name) only to my Values (Total).