Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Pieter_parker
Frequent Visitor

show items with no data

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. 

 

missing_data.png

 

Can you see any solution here? Thanks in advance! 

 

Regards,

Piotr

7 REPLIES 7
Anonymous
Not applicable

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

dtjdtj
Advocate I
Advocate I

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

 

AmiraBedh
Resident Rockstar
Resident Rockstar

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.


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

I went there as you proposed and I see no such option as "include empty categories". 
Annotation 2023-02-24 165223.png

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

 

Thanks for your suggestion! 

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.


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

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!

What type of visual you are using ?


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors