cancel
Showing results for
Did you mean:
Highlighted
Regular Visitor

## Visualize last value of a gauge

Hello everyone,

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

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

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

#### Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

#### Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!