Missing marker in line chart

[justinepolanic]

Hi there,

I'm having trouble with the below line chart:

As you can see, there is no marker for August. This is because for the Orange series, the count was 0 for August, but I would still like there to be a marker so the line doesn't get disconnected. Is there any way to do this?

[v-nmadadi-msft · Accepted solution]

Hi @justinepolanic  ,
Thanks for reaching out to the Microsoft fabric community forum.

Please try using this DAX measure

Count (With Zero) = 
COALESCE(SUM('Data'[Count]), 0)

Uploaded the sample .pbix for reference.

I hope this information helps. Please do let us know if you have any further queries.
Thank you

[justinepolanic]

Hi there,

Thank you so much! Part of my problem was that I didn't have the data in "Issue Category" represented as numerical. I added a column beside "Issue Category", used '1' to represent each entry, and the DAX measure you gave me worked!

[PBIGuy25]

Is it possible for you to upload an example PBI? I can look at your data and measures and maybe figure out something.

[Tahreem24]

@justinepolanic Workaround is to create a measure by adding +0 which will replace blank row with 0 and then it will appear with marker on the line chart.

MEASURE = Table[ColumnName] + 0

[justinepolanic]

Hi there,

Thank you for your response!

I tried your suggestion but am getting an error message after I enter the formula that says, "A single value form column 'Issue Category' in table 'Work Orders' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result".

This is how I've typed the formula: Measure = 'Work Orders'[Issue Category] + 0

[Tahreem24]

@justinepolanic  What's the data type of Issue Category column? It shouls be numeric data type (whole number /decimal number)

[justinepolanic]

Hi there, the data is not numerical, it is text. Is there a way I can add or convert to a numerical value to the data in the Issue Category column?

[Tahreem24]

@justinepolanic Then how can you put text column on Y-axis of the line chart? You need to create a measure which I shared for Y-Axis column.

[justinepolanic]

Hi there,

This is an example of my data set:

I have my Y-axis set up as "Count of Issue Category".

[pbiuseruk]

Hi,

There isn't an actual way to do this unless you set the minimum value of the x axis to something less than 0 - e.g. you could set it to -1 and then it will the whole line. 

Bit annoying because I've been frustrated with this aswell. Alternatively, you could maybe try to change the count to something like 0.01 and see if that works - although, you may end up misleading users if they hover over it and see that value.

Hope that helps. 

[justinepolanic]

Thank you for your quick response!

I had the same thought of changing the minimum value to -1, but unfortunately it didn't resolve the issue for me. Is there another setting I need to adjust in order for that to work?

[MasonMA]

Normally the issue happens because Power BI doesn’t plot a data point when that (Month, Series) pair doesn’t exist in the result set, even if the logical count is 0. 

To fix it, ensure your visual includes all series-month combinations (via a series table or “Show items with no data”) and your measure returns 0 instead of BLANK by using COALESCE( <your Measure>, 0 )