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
Icon for Resident Rockstar rankResident 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.