Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Sign up nowGet Fabric certified for FREE! Don't miss your chance! 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/
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 64 | |
| 63 | |
| 49 | |
| 21 | |
| 18 |
| User | Count |
|---|---|
| 119 | |
| 117 | |
| 38 | |
| 36 | |
| 29 |