Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear all,
This is how my matrix looks like. I would like to color the column "2C" always, no matter what the value is.
Conditional formatting only permits to apply based on inventory value (the numbers you see)
Appreciate your help.
Solved! Go to Solution.
Hi @javieezy ,
Create measure:
color = IF(MAX('Table'[Block]) = "2C", "red")
Then set background color based on "color" field in advanced contrals.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @javieezy ,
Create measure:
color = IF(MAX('Table'[Block]) = "2C", "red")
Then set background color based on "color" field in advanced contrals.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-kkf-msft
i tried same way for matrix data of mine and conditional formating is no longer valid if we expand the data. kindly help me out
Re: conditional formatting in matrix data - Microsoft Power BI Community
https://drive.google.com/file/d/1N8_8G0EGT0TLwvi1FeAJgD0AQ-WUK_gC/view?usp=sharing
Hi @javieezy ,
This can be achieved by using "Field Formatting". Make to you turn on "Apply to Header" and select whatever color you want as font and background.
Please mark as solution and give Kudos is it helps you.
Thanks,
Dheeraj
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |