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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

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
Solution Sage
Solution Sage

@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
Solution Sage
Solution Sage

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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

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