show items with no data

Question

Hello everyone,&nbsp;I have the following issue:&nbsp;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.&nbsp;Example:So as below, I want to display also 2023-05 which is missing in the chart below. Ideally, there should be 0.&nbsp;&nbsp;&nbsp;Can you see any solution here? Thanks in advance!&nbsp;&nbsp;Regards,Piotr

anthonyflynn · Answer

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.&nbsp;Thanks for your help!

amirabedh · Answer

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&nbsp;the "Format" tab in the Visualizations pane. You need to expand the "X-Axis"&nbsp; section.Look for the "Include empty categories" option and turn it on by toggling the switch to the right.

anonymous · Answer

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 · Answer

What type of visual you are using ?

amirabedh · Answer

Based on the screedshot you provided, under X-axis &gt; "Type"&gt; "Categorical" &gt; 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.

Forum Discussion

show items with no data

7 Replies

Related content

Column Item Showing as [list]

Workspace not showing Fabric items

Onelake File Explorer showing all items

List slicer - Show only selected items

Show Items With No Data