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.
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
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
4 Replies
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)
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