Suppress zero values in Power BI Line graph

Question

I am attempting to make a graph that has one column with a full month of data (black bars), and one column that fills up as the days of the month progress (green bars). I would also like to track the percentage of the forecast achieved each day as a line graph (red line) on the secondary axis.

The problem I am having is that it does not appear that one can exclude values that are zero. So in the graph I would like to have the red line disappear once the values become zero so that there isn't a massive drop of like in the image shown.

Create a calculated column where the values are blank() when the original column is zero. — StelioK
– StelioK, Commented Oct 8, 2018 at 14:54
I used the below function with BLANK() incorporated: = Table.AddColumn(#"Filtered Rows1", "Custom", each if [#"%difference"] = 0 then BLANK() else [#"%difference"]) The error I am receiving now is the saying that the name BLANK() is not recognised. — Hein Thetard
– Hein Thetard, Commented Oct 9, 2018 at 10:47

Hein Thetard · Accepted Answer · 2018-10-09 12:59:00Z

1

To fix this problem I inserted a blank spot if the condition is true. That is a "" after the 'then' statement to force a NULL. After this I changed the data type to percentage. The code is shown below and the resulting graph is shown afterwards.

= Table.AddColumn(#"Filtered Rows1", "AdjDiff", each if [#"%difference"] = 0 then "" else if [#"%difference"] <> 0 then [#"%difference"] else null)

answered Oct 9, 2018 at 12:59

Hein Thetard

371 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

StelioK Over a year ago

Good job Hein, nice solution.

Collectives™ on Stack Overflow

Suppress zero values in Power BI Line graph

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related