Forum Discussion
Table not showing dates with no data
Hi,
I have a line chart with Number of sales by month, but the table does not show the monhs in which there is no data.
4 Replies
- Ritaf1983
Super User
Hi Anonymous
To show the months without data, you can click on axis X and check the option: " Show items with no data".
Please refer to the attached picture:If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Ritaf1983 thank you! and there is a way to see the data label icon? (a zero)
- Ritaf1983
Hi Anonymous
In this context, it's not 0....but you don't have any data.
If zero is mandatory, then you need to build a measure with dax manipulations so that there will be zero in months with no activity.
Please post a separate question with an example of your data tables and a measure you calculate
