Forum Discussion

justinepolanic's avatar
justinepolanic
Regular Visitor
10 months ago
Solved

Missing marker in line chart

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    10 months ago

    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

pbiuseruk's avatar
pbiuseruk
Icon for Resolver IV rankResolver IV
10 months ago

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's avatar
    justinepolanic
    Regular Visitor
    10 months ago

    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's avatar
      MasonMA
      Icon for Super User rankSuper User
      10 months ago

      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 )