Conditional Formatting in Matrix header!

Power BI
1

Hi Team,

I have a requirement which I am not sure how to solve. I want to conditionally format background of a header in the matrix visual. But I can’t see any option to set colour of the header dynamically in the matrix. Did anyone implement any workaround?

image
image1099×328 18.5 KB

Sample file is attached.

sample model.pbix (2.4 MB)

1 Like
2

Hi

As you can see in the below image that power bi do not give us any option on conditional formatting for headers in table or matrix visual:
image

For work around you need to create whole background for the table and on that you can do the conditional coloring.

Hopefully i am clear to you if not just let me know i try to show you with and example.

Thanks

3

Hi @Anurag ,

Thanks for your response. Yes, I was thinking the same that there is no option of conditional formatting of headers. What my end user expectation is that they want to provide different colours to different regions to make it more visible to end users like below:

image
image1059×223 15 KB

How can I achieve this? Do you have any idea? Sample file is attached.
sample model.pbix (2.4 MB)

Kind Regards,
Naila

4

Hi ,

To achieve the above output like show in the below screenshot:

image
image837×285 10.7 KB

Steps you need to follow :

  1. Set style to none

image

  1. Turn off the background
    image

After doing above step you end up getting a transparent table

image
image859×224 19.9 KB

4.The last step can be done in two way either create a theme in other tool and put your table above that theme or you can use shape how i used to create the above expected output result.

Attaching the pbix for your refrence:
sample model.pbix (2.4 MB)

Thanks

5

This might help

6

Thank you to all the contributors of this post.

Hi @Naila, due to inactivity, a response on this post has been tagged as “Solution”. If you have any concern related to this topic, you can create a new thread.