Forum Discussion
Area Chart isn't showing zero values
I am trying to create an area chart using a table that I have called 'data'. Each row in the table is a help desk ticket. Each ticket has a Category. I am trying to get the count of tickets (rows) by Category for each day for the last 2 weeks. I made the below area chart to display the top 5 categories, but it's not showing me when the count dips to zero. The red line below shows where it should've dipped.
I have "show items with no data" checked on my x-axis field, but it seems to do nothing.
To fix the issue:
Add a Date Table: Create a date table covering the last two weeks and relate it to CreatedDate.
Use Date Table on X-Axis: Replace CreatedDate with the date column from the date table and check "Show items with no data."
Adjust Measure: Use a measure like this to ensure zero counts display:TicketCount = COUNT('data'[Category]) + 0.
- Filter Top Categories: Apply a visual filter for the top 5 categories.
This ensures zero values appear in the chart.
Thanks for the replies from Ritaf1983, rohit1991 and Ashish_Mathur.
Hi Celiaa ,
I have created simple data.
The steps are as follows:
1.Create a new table:
2. Create the relationship as shown:
3. Create a measure:
Measure = COUNT('Table'[Category])+0The original visual:
Result:
Best Regards,
ZhuIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
rohit1991Super User
To fix the issue:
Add a Date Table: Create a date table covering the last two weeks and relate it to CreatedDate.
Use Date Table on X-Axis: Replace CreatedDate with the date column from the date table and check "Show items with no data."
Adjust Measure: Use a measure like this to ensure zero counts display:TicketCount = COUNT('data'[Category]) + 0.
- Filter Top Categories: Apply a visual filter for the top 5 categories.
This ensures zero values appear in the chart.
- Ashish_Mathur
Hi,
Share some data to work with and show the expected result in a simple table format. Share data in a format that can be pasted in an MS Excel file.
Thanks for the replies from Ritaf1983, rohit1991 and Ashish_Mathur.
Hi Celiaa ,
I have created simple data.
The steps are as follows:
1.Create a new table:
2. Create the relationship as shown:
3. Create a measure:
Measure = COUNT('Table'[Category])+0The original visual:
Result:
Best Regards,
ZhuIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
