Hello everyone, it's my first post here, I'm quite new to Power Bi and still discovering it.
I do have a problem, hope you can help me.
I have some data for some years, 2018, 2019, no data for 2020, blank space for 2021 - to be added in soon.
For some reason when I generate the graph I get 2020 included in the graph even if there is no data associated with it, I would like to take 2020 out.
Photos attached.
Hope you can help
Many thanks !
Set the filter "on this visual" for "Numbers" to not blank and not 0
Alternitavely you can edit the measure you're using and use IF() statement like so:
Numbers =
VAR _numbers = SUM(Numbers)
RETURN
IF( ISBLANK (_numbers) || _numbers = 0, BLANK(), _numbers)
Set the filter "on this visual" for "Numbers" to not blank and not 0
Alternitavely you can edit the measure you're using and use IF() statement like so:
Numbers =
VAR _numbers = SUM(Numbers)
RETURN
IF( ISBLANK (_numbers) || _numbers = 0, BLANK(), _numbers)
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.
