March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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/
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
93 | |
87 | |
84 | |
76 | |
49 |
User | Count |
---|---|
163 | |
148 | |
103 | |
74 | |
55 |