Forum Discussion

justinepolanic's avatar
justinepolanic
Regular Visitor
1 year 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
    1 year 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

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
1 year ago

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's avatar
justinepolanic
Regular Visitor
1 year ago

Hi there,

 

This is an example of my data set:

 

 

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