display latest value in bar graph

[PraveenRaj]

 Hi everyone, i'm logging temperature readings into mssql db, i'm using import query method to display the data, I need to design a bar graph that only showing latest value of temperature, is it possible?. Till now i'm using line graph to display all time series data. But i need latest value alone in Bar graph. Help me to do it.

[v-cherch-msft · Accepted solution]

Hi @PraveenRaj

Could you share your simplified data sample and expected output? Please refer to this post How to Get Your Question Answered Quickly. You can also upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.Below is the post about getting latest value for your reference.

https://community.powerbi.com/t5/Desktop/Finding-the-most-recent-value-in-another-table/m-p/581061#M...

Regards,

Cherie

[PraveenRaj]

Thank you for your response sir, Next time i will follow the procedure to get answer quickly. Now i found the solution my query by using timestamp in filter.