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

justinepolanic's avatar
justinepolanic
Regular Visitor
10 months ago

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

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

 

 

  • justinepolanic's avatar
    justinepolanic
    Regular Visitor
    10 months ago

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

        Hi there,

         

        This is an example of my data set:

         

         

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