Remove year from visual if no data

[Anonymous]

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 ! 

[Anonymous]

Thank you very much

[Yggdrasill · Accepted solution]

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)