Forum Discussion
Helper IIIcalculation on Guage
Hi All,
Could some one please help me on the below calculation and the chart type which i shared as i need to show the calculation on this chart
calculation:
Green = YTD Actual better than YTD prior year;
Yellow = YTD Actual = YTD previous year
Red = YTD actual worse (less) than YTD prior year
Regards
Anitha.
You can find the conditional formatting under format tab as below-
Click fx and then a window will open where you explore the options to set up what you want.
Also check this - https://radacad.com/sentiment-colors-for-gauge-visual-in-power-bi
Appreciate your kudos!! Please mark my post as solution if this helps you.
3 Replies
If you have measures already created, you can set the color using conditional formatting.
Appreciate your kudos!! Please mark my post as solution if this suits your requirement.
anithaMallamHi,
this is the condition that i have use and i want to know how to write the condition which i can use it on guage
Green = YTD Actual better than YTD prior year;
Yellow = YTD Actual = YTD previous year
Red = YTD actual worse (less) than YTD prior year.
and i didnt find conditional formatting on Guage.Could you please provide more details on this it would be helpful.
Regards
Anitha.
You can find the conditional formatting under format tab as below-
Click fx and then a window will open where you explore the options to set up what you want.
Also check this - https://radacad.com/sentiment-colors-for-gauge-visual-in-power-bi
Appreciate your kudos!! Please mark my post as solution if this helps you.