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.
I have a bar chart with a date on the x-axis and a $ amount as the value. When I make a year selection in a slicer, several of the values in the bar chart go to zero. Is it possible to remove the data labels in the bar chart when the value is 0?
Solved! Go to Solution.
Rewrite your measure to use a variable and an IF statement to blank out zeroes. Assuming your measure is something like:
Sales = SUM(SalesTable[Amount])
...you would rewrite it as:
Sales = VAR result = SUM(SalesTable[Amount]) RETURN IF(result = 0, BLANK(), result)
This will turn zeroes into blanks, which do not show up in data labels.
Proud to be a Super User!
Hi @mjmar025,
Could you please mark the proper answer if it's convenient for you? That will be a help to others.
Best Regards!
Dale
Rewrite your measure to use a variable and an IF statement to blank out zeroes. Assuming your measure is something like:
Sales = SUM(SalesTable[Amount])
...you would rewrite it as:
Sales = VAR result = SUM(SalesTable[Amount]) RETURN IF(result = 0, BLANK(), result)
This will turn zeroes into blanks, which do not show up in data labels.
Proud to be a Super User!
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 |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |