Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin 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.
Dear Great Community, is it possible to hide some cards if multiple selections applied in the slicer??
to be more clear, the case is I have some cards data are percentage by month when i select two or three months to see other data its give a wrong value regarding this cards and in the same time i have one month only with no data for these cards so i need to hide them or "to record no data" in both cases 1- if January (one month) selected 2- if multiple months selected.
hope my question is clear to you and thank you for your help in advance
Solved! Go to Solution.
Hi @NourJ,
We cannot hide the card here, we can show the value blank to work around.
Here we can create a measure as below.
Measure = var sele = SELECTEDVALUE(Table1[date]) return IF(CALCULATE(DISTINCTCOUNT(Table1[date]),ALLSELECTED(Table1))>1,BLANK(),CALCULATE(SUM(Table1[value])))
For more details, please check the pbix as attached.
Regards,
Frank
Hi @NourJ,
We cannot hide the card here, we can show the value blank to work around.
Here we can create a measure as below.
Measure = var sele = SELECTEDVALUE(Table1[date]) return IF(CALCULATE(DISTINCTCOUNT(Table1[date]),ALLSELECTED(Table1))>1,BLANK(),CALCULATE(SUM(Table1[value])))
For more details, please check the pbix as attached.
Regards,
Frank
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 79 | |
| 38 | |
| 31 | |
| 27 | |
| 27 |