Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 !
Solved! Go to 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)
Thank you very much
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |