Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
Solved! Go to Solution.
@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
Thank you both. This helps a lot.
@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
@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/
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!