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!