Forum Discussion
Conditional Format Gauge Charts
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:
- Create a measure:
Color = IF([Percent]<[Target1],"Red","Blue")- Create a gauge chart and set the data color like this:
- Then create a slicer to slice the data based on week number, and you can get what you want, like this:
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:
- Create a measure:
Color = IF([Percent]<[Target1],"Red","Blue")- Create a gauge chart and set the data color like this:
- Then create a slicer to slice the data based on week number, and you can get what you want, like this:
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.