How to conditional format fields in the rows bucket in matrix visualisation

[Anonymous]

Hi there,

It is widely known that matrix visualisation in Power BI only allows for conditional formatting of fields in the Values bucket. However, I need to conditional format a field in the Rows bucket. In my case, any values above 300 for Act vs Hedge will be displayed as a red font while values below 300 will be displayed as a black font.

What I have: 

What I need:

I have tried various workarounds and searched on the net for solutions but to no avail. The closest solution I found was to add indicators using image url but this was not what I needed as well (https://www.youtube.com/watch?v=7C1vpG-JQ9I). 

Looking forward to all of your responses 🙂

Thanks and regards,

Ben

[v-yangliu-msft]

Hi  @Anonymous ,

This function power bi is temporarily unavailable, you can put forward your ideas and vote on the following URL：

https://ideas.powerbi.com/ideas/

Best Regards,

Liu Yang

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

[Anonymous]

Hi @v-yangliu-msft ,

Thanks for the information. I have posted my suggestion in the forum mentioned. In the meantime, if anyone has any workarounds to achieve what I need, please feel free to post here as well 🙂

Thanks and regards,

Ben

[v-yangliu-msft]

Hi  @Anonymous ,

Here are the steps you can follow：

You can set Conditional formatting for them separately to individually change the data color in each Row

1. You can find [Act vs Hedge] in Fileds and select Conditional formatting – Background color.

2. Enter the Background color interface, set Format by -Rules, and customize the color rules.

3. In Format, find Conditional formatting, set Background color to OFF, Font color to On.

4. Result:

Best Regards,

Liu Yang

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

[Anonymous]

Hi @v-yangliu-msft ,

From your file, the Act vs Hedge field is in the Values bucket. In my post, I mentioned that my Act vs Hedge field is in the Rows bucket. I am trying to find out how to conditional format fields in the Rows bucket. Hope this clarifies.

Thanks and regards,

Ben