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 ...
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)