Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
69 | |
68 | |
40 | |
29 | |
26 |
User | Count |
---|---|
88 | |
49 | |
45 | |
38 | |
37 |