Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
id013
Helper V
Helper V

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 

1 ACCEPTED SOLUTION
HarishKM
Impactful Individual
Impactful Individual

@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 .

HarishKM_1-1617163788088.png

 

 

HarishKM_0-1617163716968.png

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

 

 

View solution in original post

3 REPLIES 3
id013
Helper V
Helper V

Thank you both. This helps a lot. 

HarishKM
Impactful Individual
Impactful Individual

@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 .

HarishKM_1-1617163788088.png

 

 

HarishKM_0-1617163716968.png

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

 

 

amitchandak
Super User
Super User

@id013 , 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/

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.