cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## 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

2 ACCEPTED SOLUTIONS
Super User

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

Helper I

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

3 REPLIES 3
Super User

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

Helper I

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

Super User

I agree with your measures. (^^)

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors