show items with no data

[Pieter_parker]

Hello everyone,

I have the following issue: 

I want to keep the month on the x-axis constant. So even when I have no data for my month I want to display such month and show the value of 0 (or just an empty value) for that month. So I have two variables in my dataset:

1. items sales,

2. date in months.

Example:

So as below, I want to display also 2023-05 which is missing in the chart below. Ideally, there should be 0. 

Can you see any solution here? Thanks in advance! 

Regards,

Piotr

[Anonymous]

@AmiraBedh - would you kindly add the screenshot ? My case is for the Matrix.

[dtjdtj]

Does someone know how to show items with no data in a table? Thanks!

[AmiraBedh]

By default, Power BI will not show items with no data in a chart. However, you can change this behavior and display items with no data in the "Format" tab in the Visualizations pane. You need to expand the "X-Axis"  section.Look for the "Include empty categories" option and turn it on by toggling the switch to the right.

[Pieter_parker]

I went there as you proposed and I see no such option as "include empty categories". 

I also tried to convert it into type of continuous but also didn't help.

Thanks for your suggestion! 

[AmiraBedh]

Based on the screedshot you provided, under X-axis > "Type"> "Categorical" > select the field that you want to show items with no data for.

Under"Category labels", turn on the "Show items with no data" toggle.

[AnthonyFlynn]

Hi AmiraBedh,

I am encountering exactly the same problem.

I am using the standard line chart and I cannot find the option "Show items with no data".

Before the update of the format pane it was available.

Thanks for your help!

[AmiraBedh]

What type of visual you are using ?