Forum Discussion

RingoSun's avatar
RingoSun
Helper II
4 years ago
Solved

Issue when using a visual to filter other visuals

 

 

Okay so I have this line graph visual above. And basically I am getting the total quantity of Client brand only for each quarter. More specifically, I am only getting the total quantity from the last month of each quarter, so for Q1 I'm only getting the total quantity from March, for Q2 I'm only calculating June, and so on.

 

It can be seen that in Q1-2021, Client has 220 as its quantity. So if I click on Q1-2021 on the line graph, I expect that in my bar graph visual, the Client brand will only show me 220 as its quantity as well, but that is not the case, the Client brand is showing me 445 quantity

 

I imagine it's probably getting the total quantity for the whole quarter instead. How do I prevent that and make it follow the line graph quantity instead?

 

SAMPLE PBIX

 

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hello

     

    If you put the measure total qty for the first graph it will work

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hello

     

    If you put the measure total qty for the first graph it will work