Forum Discussion
How to filter a graph visual only using select columns from a table visual?
Hi P_BI_Noob
Do you hope to realize something like this? When selecting a row, the line graph should show the payments of the specific person?
I create a measure [# Payment] to get the latest payment.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
P_BI_Noob , Create these measure and user
Last Qty = Var _max = maxx(filter( ALLSELECTED(Data1), Data1[M Name] = max(Data1[M Name]) && Data1[F Name] = max(Data1[F Name]) && Data1[L Name] = max(Data1[L Name]) ),Data1[Date])
return
CALCULATE(sum(Data1[payment]), filter( (Data1), Data1[M Name] = max(Data1[M Name]) && Data1[F Name] = max(Data1[F Name]) && Data1[L Name] = max(Data1[L Name]) && Data1[Date] =_max))
Sum Last Qty = sumx(VALUES(Data1[ID]) , [Last Qty])
Latest Date
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0
Thank you for the response, however I do not believe this fully answers my question. I want the table visual to display the latest payment AND I want the graph visual to display the full history of payments once I select the latest payment from the table visual.
When I select a latest payment from the table visual currently, the graph visual is filtered down to only the latest payment and not the full history of paymentsHi P_BI_Noob
Do you hope to realize something like this? When selecting a row, the line graph should show the payments of the specific person?
I create a measure [# Payment] to get the latest payment.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!Yes this is exactly what I wanted to accomplish, I did not include the date in my original table and thus did not use the latest summary option which led to my problems. Thanks for the example!
