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 All,
I am trying to format a % measure called "Learning Percentage Completed" with red when it's >50 and <75 then with orange when its greater than 75. I've created a new measure called "color measure" and have tried using a IF statement ( I need to additional conditions later on).
When I just return the number from the IF it returns the correct number;
Color Measure =
VAR _per = [Learning Percentage Completed]*100
RETURN
_per
But when I try comparing the numbers they are all orange when only 84.59 should be orange.
Color Measure =
VAR _per = [Learning Percentage Completed]*100
RETURN
IF(_per >50 && _per < 75, "Red","Orange")
This should be pretty simple but what am I missing?
Thanks
Solved! Go to Solution.
@ringovski , This seems fine .
Try this
Color Measure = Switch( True() ,
[Learning Percentage Completed] >.5 && [Learning Percentage Completed] <.75, "Red",
"Orange"
)
If this does not help
Can you share a sample pbix after removing sensitive data.
@ringovski , This seems fine .
Try this
Color Measure = Switch( True() ,
[Learning Percentage Completed] >.5 && [Learning Percentage Completed] <.75, "Red",
"Orange"
)
If this does not help
Can you share a sample pbix after removing sensitive data.
I got it by adding a third condition, as it is technically correct at the moment becuase it changing values below 50 as these aren't 50 to 75.
Color Measure =
VAR _per = [Learning Percentage Completed]*100
RETURN
IF(_per >50 && _per < 75, "Red",
IF(_per > 75, "Orange",""))
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 | |
23 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
42 | |
39 | |
19 | |
19 |