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 have a case related to text coloring based on predefined conditions (<95% green, 95-99% yellow, > 100% red). currently I use the color feature in the data label, but the colors that appear do not match, some are >100% red, some are green.
the following measures I use :
IF(SELECTEDVALUE('2 Operation Metrics'[Operational Metrics]) = "Productivity",
IF(SELECTEDVALUE('2 Operation Metrics'[Product]) = "Gondorukem",
IFERROR("(" &ROUND(100*([_OM_Actual]/[_OM_Target]),0)& "% Target)", "N/A"),
IFERROR("(" &ROUND(100*([_OM_Actual_Average]/[_OM_Target_Ach]),0)& "% Target)","N/A")),
IFERROR("(" &ROUND(100*([_OM_Actual_Average]/[_OM_Target_Ach]),0)& "% Target)","N/A"))
I want to create conditions using measures not using color labels, can anyone help me with what steps?
Solved! Go to Solution.
Maybe this topic will help you:
https://community.powerbi.com/t5/Desktop/dynamic-rule-for-changing-color-of-a-measure/m-p/1100128
This measure with the colours that you created must be used in conditional formatting not in the values section of the visual.
So, add a card visual (if this is the visual that you use)
Add the metric _OM_YTDSnapshotRendemen to this visual
Now go to format options of the visual --> Click on Data Label --> then fx
Format by: Field
Select the new measure field that you created with the color formula
Maybe this topic will help you:
https://community.powerbi.com/t5/Desktop/dynamic-rule-for-changing-color-of-a-measure/m-p/1100128
I tried but the result that appears error x
measures _OM_YTDSnapshotRendemen :
IF(SELECTEDVALUE('2 Operation Metrics'[Operational Metrics]) = "Productivity",
IF(SELECTEDVALUE('2 Operation Metrics'[Product]) = "Gondorukem",
IFERROR("(" &ROUND(100*([_OM_Actual]/[_OM_Target]),0)& "% Target)", "N/A"),
IFERROR("(" &ROUND(100*([_OM_Actual_Average]/[_OM_Target_Ach]),0)& "% Target)","N/A")),
IFERROR("(" &ROUND(100*([_OM_Actual_Average]/[_OM_Target_Ach]),0)& "% Target)","N/A"))
It seems that the measure _OM_YTDSnapshotRendemen doesnt return a number but a text. Is that correct?
Try to wrap this measure in a VALUE function. Like below:
VALUE([_OM_YTDSnapshotRendemen])>100, "Red"
for the number it's not text but I added punctuation text () & and Target text, I've temporarily deleted () & and Target but what comes out is not a colored number but text as I screenshot.
This measure with the colours that you created must be used in conditional formatting not in the values section of the visual.
So, add a card visual (if this is the visual that you use)
Add the metric _OM_YTDSnapshotRendemen to this visual
Now go to format options of the visual --> Click on Data Label --> then fx
Format by: Field
Select the new measure field that you created with the color formula
thank you case resolved.
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 |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |