Forum Discussion

id013's avatar
id013
Helper V
5 years ago
Solved

Can one visual filter another

Hi, I'm just wondering if something like this is possible. I would like to have 2 visuals one that shows Sales Values for multiple years and another that shows sales values for a single year but for...
Need Help
  • HarishKM's avatar
    HarishKM
    5 years ago

    id013 
    Hey ,You can use below measure to fulfill your requirement .

    Viz = IF(SELECTEDVALUE(financials[Year]),SUM(financials[ Sales]),BLANK())  
    drag that measure to 2nd viz it will show blank until you will pass the year value from slicer .

     

     



    Note: Kindly select any viz go format and edit interaction : 1st chart will not affected by year slicer and 2nd chart will affected by that and it will show value when year is selected

     

     

HarishKM's avatar
HarishKM
Super User
5 years ago

id013 
Hey ,You can use below measure to fulfill your requirement .

Viz = IF(SELECTEDVALUE(financials[Year]),SUM(financials[ Sales]),BLANK())  
drag that measure to 2nd viz it will show blank until you will pass the year value from slicer .

 

 



Note: Kindly select any viz go format and edit interaction : 1st chart will not affected by year slicer and 2nd chart will affected by that and it will show value when year is selected