Games by Month - show 0 values

[paulvans182]

Good morning,

I hope someone can help me.  I have a data model where I have 3 tables:

Game Data, Meta Data, Meta Calendar

In the table Meta Data, I have 2 columns: Game ID and Date.  I have created a master calendar (Meta Calendar), that is joined to the Meta Data table providing all possible dates between the first and last date and the Meta Data table.

I have created a Measure to count the Total number of games in the Meta Data table.  

I am trying to create a visual that shows a Bar Chart with the Months on the X-Axis and the count of games each month in the Y-Axis. 

This almost works correctly, however, in my data I have several months where no games were played.  I would still like to see these months on the X-Axis.

I there a way I can show them?

Thank you for you help.

Paul

[V-lianl-msft · Accepted solution]

Hi @paulvans182 ,

Right-click on your axis and select "Show items with no data", you are able to display several months where no games.

Best Regards,

Liang

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

[paulvans182]

Thank you so much!

That is excellent. I really appreciate your help