Forum Discussion
How to show all data from value
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
Hi Bal
According to the first question, please refer to my answer with detailed explanation in the linked discussion :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
2 Replies
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
Hi Bal
According to the first question, please refer to my answer with detailed explanation in the linked discussion :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
