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.
I'm trying to set different conditional formatting ranges based off slicer selections in a gauge. We have two different departments with separate goals for the same value field. I'd like to be able to show different ranges for red, yellow, green based off department selections from the slicer. I read another post and might be heading down the wrong path, but they had suggested setting up a color measure - but now if I go to format style by field value, that measure is grayed out and I can't use it . Am I on the right path, or is there a better way to accomplish this? I'm fairly new to PowerBI, but this is where I'm at currently at whith building the color measure
You can fix it in 3 steps:
1. Set one color in the measure without any conditions
2. Set this measure for visualization
3. Set the right condition in the measure to calculate the color
p.s. Setting the measure type as "Text" has helped in the past, but that no longer works for me now
Hi @bpowers2 ,
I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.
Thanks for your efforts & time in advance.
Best regards,
Community Support Team_Binbin Yu
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 |
---|---|
109 | |
108 | |
88 | |
75 | |
66 |
User | Count |
---|---|
125 | |
114 | |
98 | |
81 | |
73 |