How to create a measure that changes cell colour/font colour in a table filtered by a slicer?

[Anonymous]

HI, I would like to have my filtered table (from a slicer) display the different services with different font colour/cell background colour. Any idea how i can create a measure to detect that the service code is different from my table that is filtered from a slicer?

So i have filtered the service code to display services 040 and 822 in my table below. How can i create a measure so that columns for 040 are in red, or in another cell colour? This is so that i can easily see the 2 services. 

This is how i created my slicer and table from my sources which is an excel file

Thank you in advance for any help rendered!

Regards

Felibhai

[Anonymous]

Hello,

first you need to write a measure. Then in the formatting section under condition formatting select background color and go to the advanced controls. Then insert the measure and select the values.

If this works, please mark it as the solution, thanks 🙂

[Anonymous]

HI, thanks for your reply!

However, i dont want to assign a fixed svc code, rather i would like the measure to run down the selected column, and return a 1 if the value of the first column is different. so when measure is 1, i can use it to assign another colour. 

My list has a thousand and more services, so it would be too tedious to assign every option, as the user is able to select many services based on the slicer

THanks a lot!