cancel
Showing results for
Did you mean:
Regular Visitor

## Visualize last value of a gauge

Hello everyone,

I already seen before this question but I never had and answer about it.

So there is my problem I have some data that I want to display in a gauge but when I do it the gauge show to me the sum or the max of the data. I don't know how to get the last value in my table.

I tried to correct this problem by adding a filter with top N and by the value the latest date but when I do that I have the lastest value but the max value isn't right I just getting the double of the value

Can you help me please?

Thank you in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III

## Re: Visualize last value of a gauge

Apologies. This is what I get just typing formulas into the forum instead of checking the syntax.  Wrapping it in a FILTER should fix that issue:

`LatestValue = CALCULATE( SELECTEDVALUE(Table1[Value]), FILTER(Table1, Table1[Date] = MAX(Table1[Date])) )`
5 REPLIES 5
Super User III

## Re: Visualize last value of a gauge

What do you want the max value of the gauge to be?  PowerBI assumes double the current amount if no value is given.

Regular Visitor

## Re: Visualize last value of a gauge

I want the latest value in my table which is display on the enter of the gauge and I want also the max value display and not the double of my latest value

See below the position:

Super User III

## Re: Visualize last value of a gauge

Ahh, looks like you need to create your own measure here.

First thing I would do would be to remove your visual level filter that's only pulling the Top 1 value by latest date.  Then set the max of your gauge to the max of Value.

Then to get today's value for the position of the gauge, we create a measure like so:

`LatestValue = CALCULATE( SELECTEDVALUE(Table1[Value]), Table1[Date] = MAX(Table1[Date]) )`

Drop that into your visualization bucket and you're good to go.

Regular Visitor

## Re: Visualize last value of a gauge

I have an error when I copy paste your function I replace the nam of the table but when I replace Table1[Date] Powr BI say that the function MAX is used in a true/false expression and can't be used for the table filter

Super User III

## Re: Visualize last value of a gauge

Apologies. This is what I get just typing formulas into the forum instead of checking the syntax.  Wrapping it in a FILTER should fix that issue:

`LatestValue = CALCULATE( SELECTEDVALUE(Table1[Value]), FILTER(Table1, Table1[Date] = MAX(Table1[Date])) )`

Announcements

#### Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

#### Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors