Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 ju...
Need Help
AmiraBedh's avatar
AmiraBedh
Super User
3 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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's avatar
    AmiraBedh
    Super User
    3 years ago

    What type of visual you are using ?

  • AmiraBedh's avatar
    AmiraBedh
    Super User
    3 years ago

    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's avatar
      AnthonyFlynn
      Regular Visitor
      3 years ago

      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!