Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
HI, i have a simple question, how can established a conditional format in a gauge chart based on a mobile target?, i mean, i have a diferent target every week and i need that the graph change between green and red depending on that
Solved! Go to Solution.
Hi, @JoseDavidM
According to your requirement, I think that you can create another measure to compare the value of the two measures based on the slicer. You can try this method:
Color = IF([Percent]<[Target1],"Red","Blue")
You can download my test pbix file here
If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @JoseDavidM
According to your requirement, I think that you can create another measure to compare the value of the two measures based on the slicer. You can try this method:
Color = IF([Percent]<[Target1],"Red","Blue")
You can download my test pbix file here
If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey @JoseDavidM ,
you can change the conditional format based on a measure.
And the measure can change every week based on your data.
To to the format settings of you Gauge visual and click to the function symbol next to the target color:
Then you can chose the colors based on a measure:
Hey @JoseDavidM ,
did it work with the measure in the conditional formatting?
I'm curious if you could solve this issue 🙂
Thanks for the answer. actually my problem is that the rule of the conditional format depends of two fields or measures, i mean, i need that tha graph change to red when a measure is lowe thatn another measure (target).
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |