Please tell me how to display even 0 data in the category.

[Tome_05]

I have some questions, so let me ask you a question.

I created a horizontal bar graph like an image. Please tell me how to display data with a numerical value of 0 in the Y-axis category.

[isabella]

Hi @Tome_05 

I did a local test， when the sales is 0，the category E will display by default.

I have no idea why yours not，maybe you can update you  power bi desktop to the latest.

Then if this issue  still  exist，please provide us some sample data and show us how is your graph looks like ，so that we can reproduce your issue and find a solution.

Best Regards,

Community Support Team _Isabella

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Tome_05]

@tom480 , @TheoC 

Thank you for answering.
I implemented the solution immediately, but I could not display it well.

Probably because it is filtered.

What I want to do is filter the data with only the number 1 displayed in the red frame of this image to display the data.

However, when I did this, there was originally content that did not have the number 1 and it seemed that it could not be displayed.
There are 13 contents in total, but 12 have the number 1.
Since there is one data with the number 1 being 0, I want to be able to display that as well in the graph.

[TheoC]

Hi @Tome_05 if you are using Power Query to filter a number (as per the screenshot), you are effectively removing it permanently from your model.  If you want it back, go to the Applied Steps pane on the right side of the screenshot and click through to find out where you filtered the data. Once you find that step, delete it, and the filtered data will come back to being unfiltered.  Only delete that single step and then click back to the last step to get back to where you where.

Hope this helps.

Theo

[TheoC]

@Tome_05 if the solution that @tom480 put up is not what you were referring to, you can try to click on the Y-axis down arrow and select the "Show items with no data".  

[tom480]

Hi @Tome_05 ,

Is this what you are looking for?  If so, please mark as a solution to help others find the answer please.  Enjoy!  Tom 😀