Forum Discussion

JoshP11's avatar
JoshP11
Icon for Helper II rankHelper II
2 years ago
Solved

Help with donut/gauge visual

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

Need Help

3 Replies

  • mickey64's avatar
    mickey64
    Icon for Super User rankSuper User
    2 years ago

    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's avatar
      JoshP11
      Icon for Helper II rankHelper II
      2 years ago

      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