cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
elabaigt Regular Visitor
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

gauge.PNG

Parameters.PNG

 

Can you help me please?

 

Thank you in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
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])) )

View solution in original post

5 REPLIES 5
Super User III
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.

elabaigt Regular Visitor
Regular Visitor

Re: Visualize last value of a gauge

Thank you for your reply,

 

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:

gauge.PNG

Super User III
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. 

elabaigt Regular Visitor
Regular Visitor

Re: Visualize last value of a gauge

tHANKS FOR YOUR REPLY?

 

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
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])) )

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

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!

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

January 2020 Community Highlights

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

Difinity Conference

Difinity Conference

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

Top Solution Authors
Top Kudoed Authors