Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
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.
Thank you so much!
That is excellent. I really appreciate your help
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |