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 and I know how to accomplish

2. Using that filtered table, be able to click a row and show the full history of payments for each distinct F, M and L Names

Here is what I have attempted thus far:
1. The table visual uses dataset Table1, the graph visual uses

 

 

Table2 = CALCULATEDTABLE('Table1')

 

 

2. I created a measure that looks like the following 

 

 

Measure 2 = 
VAR att = SELECTEDVALUE(Table1[F Name])
VAR att_2 = SELECTEDVALUE(Table1[M Name])
VAR att_3 = SELECTEDVALUE(Table1[L Name])
VAR btt = MAX('Table2'[F Name])
VAR btt_2 = MAX('Table2'[M Name])
VAR btt_3 = MAX('Table2'[L Name])
RETURN
IF(ISBLANK(att) && ISBLANK(att_2) && ISBLANK(att_3), 1, IF(att_2=btt_2 && att=btt && att_3=btt_3, 1, 0))

 

 

The measure works if I only use F name (att and btt) as the table visual columns I want to filter on, but when I add the M and L Name variables, the measure stops working, please advise

  • 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!

4 Replies

  • 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

    https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee884e

    • P_BI_Noob's avatar
      P_BI_Noob
      Frequent Visitor

      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 payments

      • Anonymous's avatar
        Anonymous
        Not applicable

        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!