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.
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
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 🙂
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!
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
46 | |
39 | |
19 | |
19 |