Forum Discussion
Help with donut/gauge visual
For your reference.
Step 0: I use this simple data.
Step 1: I make 3 measures below.
M_Recent = SUMX(FILTER('DATA','DATA'[Group]="A"),'DATA'[Value])
M_Target = SUMX(FILTER('DATA','DATA'[Group]="B"),'DATA'[Value])
M_Max = SUMX(FILTER('DATA','DATA'[Group]="C"),'DATA'[Value])Step 2: I make a 'Gauge visual'.Thank you, that's great! I think this will work perfectly, however is there a way to write the measure to get 70% of the maximum value, rather than getting it from the data?
I had a little look and seems like this would be the approach but wanted to see if you agree?
MaxValue = MAX(MyTable[Value])
70% of MaxValue = [MaxValue] * 0.7
Thank you, that's great! I think this will work perfectly, however is there a way to write the measure to get 70% of the maximum value, rather than getting it from the data?
I had a little look and seems like this would be the approach but wanted to see if you agree?
MaxValue = MAX(MyTable[Value])
70% of MaxValue = [MaxValue] * 0.7
I agree with your measures. (^^)