How to show all data from value

[Bal]

Hello, Please help me to solve following problems, I'm new to Powe BI
1) The chart not showing all the data in "salinity", it shows the sum, I want it to show every data in salinity.
2) The gauge also only show the sum while I want it to show the latest reading

[Ritaf1983 · Accepted solution]

Hi @Bal 
According to the first question, please refer to my answer with detailed explanation in the linked discussion :

https://community.fabric.microsoft.com/t5/Desktop/Plot-Line-Chart-Industrial-Logging-without-Aggrega...

According to the gauge:

If you need the value of the last date, you should create a filtered measure like :

last_date_sales = CALCULATE(sum('Orders'[Sales]),filter('Orders','Orders'[Order Date]=max('Orders'[Order Date])))

the pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[amitchandak]

@Bal , You need to add index/ unique id column on x- axis

If you do not have one, add in power query

Power Query- Index Column: https://youtu.be/NS4esnCDqVw

Add index column axis and then exapnd