cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

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?

 

felibhai_0-1631896702193.png

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

 

felibhai_1-1631896814992.png

Thank you in advance for any help rendered!

 

Regards

Felibhai

 

2 REPLIES 2
maxigtsh
Helper I
Helper I

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.

 

sample.PNG

 

 

maxigtsh_0-1631907744903.png

 

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

Anonymous
Not applicable

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!

 

 

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!

Power BI Dev Camp Session 22 without aka link and time 768x460.jpg

Check it Out!

Watch Session 22 Ted's Dev Camp along with past sessions!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!