Morning all,
On the visual below, I would only like to show 2019 and 2022 but 2020 and 2021 are still showing on the visual although it was not selected. I have tried different methods but unable to solve this. Is there a simple solution for this?
Many thanks,
Aquarius
@Aquarius , Check have handled blank values using +0 or isblank.
or have you used this option
Other wise create a measure like this and test
if([Measure] =0, blank(), [measure])
@Aquarius , Check have handled blank values using +0 or isblank.
or have you used this option
Other wise create a measure like this and test
if([Measure] =0, blank(), [measure])
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
