Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
vellimax
New Member

Conditional Formatting

Hi,

 

I do have a question about conditional formatting and maybe one of you has a solution for it.

 

In my dashboard there is a matrix and I want to format/color the fields of CPM TL to CPM BVB based on the countries.

There is a relationship between countries of both fields to a country table which is shown as the first column.

 

If CPM TL is smaller than CPM BVB I want it to be red and if it is greater it should be green. So far I only managed to do a formatting according to the average of CPM BVB or within CPM TL (min or max).

Does anyone of you have an elegant solution on how to solve this problem?

 

vellimax_0-1658495696033.png

Please lt me know if you have any additional questions and thanks in advance.

1 ACCEPTED SOLUTION
SolomonovAnton
Solution Supplier
Solution Supplier

hello 

I think it should help you 

 

Color measure= if ([CPM TL]>[CPM BVB],"green","red")

you should apply it measure to Conditional formating->Background color-> 
Format Style - Field Value 
What field on should base this on? - [color measure]
ok

If my message helped solve your issue, please mark it as Resolved! If it was helpful, consider giving it a Kudos!

View solution in original post

2 REPLIES 2
vellimax
New Member

Thank you, that did the trick!

SolomonovAnton
Solution Supplier
Solution Supplier

hello 

I think it should help you 

 

Color measure= if ([CPM TL]>[CPM BVB],"green","red")

you should apply it measure to Conditional formating->Background color-> 
Format Style - Field Value 
What field on should base this on? - [color measure]
ok

If my message helped solve your issue, please mark it as Resolved! If it was helpful, consider giving it a Kudos!

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.