Forum Discussion

P_BI_Noob's avatar
P_BI_Noob
Frequent Visitor
2 years ago
Solved

How to filter a graph visual only using select columns from a table visual?

I have a table and graph visual that looks like the following: I want to be able to do 2 things: 1. Only display the latest row for each distinct F, M and L Names. This is starightforward...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    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!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
P_BI_Noob
Frequent Visitor
2 years ago

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!