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

Anonymous's avatar
Anonymous
Not applicable
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

  • justinepolanic's avatar
    justinepolanic
    Regular Visitor
    10 months ago

    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!