Forum Discussion
circle gauge / donut
jaspijk I saw another post from v-zhenbw-msft where they did conditional formatting on a line chart, and that would also work for your donut!
You create a measure for each of the colors you want:
Measure Green = if([Measure]>80,[Measure],blank())
Measure Yellow = if([Measure]>50&&[Measure]<=80,[Measure],blank())
Measure Red = if([Measure]<=50, [Measure],blank())
then put them all in the donut values. Change the colors for each to the right color:
Updated PBIX: https://github.com/DataZoe/PBIX/blob/master/DonutShape.pbix
'm so thankfull! Can I ask one last question. I've to make the visual 36 times on 36 measerments. Di I've tot make all the measerments 36 times or is there a way to simplify that, to change only the measerment on witch the score is based. Thanks.
jaspijk Yes, you can have [Measure] be based on multiple measures this way:
1. Create a table (Enter Data) with all your base measure names:
2. Modify your [Measure] to switch between what is selected:
Measure = if(HASONEFILTER('Base Measures'[Selected Measure]), switch(SELECTEDVALUE('Base Measures'[Selected Measure]), "Base Measure 1",[Base Measure 1], "Base Measure 2",[Base Measure 2], "Base Measure 3",[Base Measure 3], "Base Measure 4",[Base Measure 4], "Base Measure 5",[Base Measure 5], blank()) ,blank() )3. Now you have 2 options, you can put a visual level filter that picks which measure is on the card/donut for each visual:
4. Or you could control one with a slicer:
I've updated the PBIX too: https://github.com/DataZoe/PBIX/blob/master/DonutShape.pbix