Forum Discussion
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 each period in that year. Is it possible to have that 2nd visual blank until a year is selected in the 1st visual, then the 2nd visual will show the values for each period in that selected year?
Thanks
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
3 Replies
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 selectedid013 , isfiltered can help in this case. For all measure in second visual , you need to have this condition
New measure =
if(isfiltered('Date'[Year]), [measure], blank())
Check this https://www.youtube.com/watch?v=hXg3kRFSGjA
or https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
Thank you both. This helps a lot.
