Help with donut/gauge visual

[JoshP11]

Hello,

I have a requirement to present a visual in PBI like the below. 

Essentially, I will have a slicer to filter on 'Name', then i need a visual to display the Maximum of a value (this represents 100%), then display the most recent of that value (this represents 55%), then ideally a target value would also display (705)

The example above is for total distance ran by 'name'. The maximum will show that most distance thats been recorded on the data, the 55% will show the last data on record. I'm not certain as of now how to incorporate the target value in my data.

Any suggestions would be massively appreciated!

Thanks,

Josh

[mickey64 · Accepted solution]

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'.

[mickey64 · Accepted solution]

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'.

[JoshP11 · Accepted solution]

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

[mickey64]

I agree with your measures. (^^)