Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Data lines with 0 values displayed anomalies when selected using a slicer

I am using the line chart to display a trend of defects by dept. Some depts has 0 defects but still required to be displayed in the chart. To do this, I added each dept defects count into the Y-axis...
Need Help
sturlaws's avatar
sturlaws
Resident Rockstar
3 years ago

Hi, Anonymous,

 

have you created a measure, or are you using an implicit measure? Do you have a date-table?

I am not able to recreate your issue, but you could try to write a measure like this:

Measure = SUMX('Table',if(ISBLANK('Table'[value]),0,'Table'[value]))

 

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi sturlaws ,

 

I am getting the data from a table like the following:

 

The following columns are selected for the Y-axis:

 

 

 

 

 

 

 

Cheers!

  • sturlaws's avatar
    sturlaws
    Resident Rockstar
    3 years ago

    How have you created your slicer?

    Anyway, the your table is not optimal for what you are trying to do. I would place department on rows instead, like this:

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi sturlaws ,

       

      I use the "Dept" as the field for the slicer.

       

      Sorry, I missed showing that in the table screenshot.