Forum Discussion
Remove year from visual if no data
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)
2 Replies
- Yggdrasill
Responsive Resident
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)