cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
filipe197 Frequent Visitor
Frequent Visitor

Display in axis X of a bar chart all months even those with no data yet

Hello guys,

 

I am building up a Dashboard to have a monthly update and i would like to display all months in the axis X regardless of the months have data to display or not. So basiclly, along the year with the updates the chart becomes more filled. Take a look for this example taken from Think-Cell tool:

 

Capturar.JPG

 

 

 

 

 

 

 

 

Is it possible to pull this off on Power Bi?

Thanks

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
prateekraina New Contributor
New Contributor

Re: Display in axis X of a bar chart all months even those with no data yet

Hi @filipe197,

 

Here is the solution.
Refer below screenshots for understanding the structure of tables.
You need to turn on "Show items with no data " for column in Axis.

Solution1.PNGSolution2.PNGSolution3.PNG

Thanks !!

3 REPLIES 3
Highlighted
prateekraina New Contributor
New Contributor

Re: Display in axis X of a bar chart all months even those with no data yet

Hi @filipe197,

 

Here is the solution.
Refer below screenshots for understanding the structure of tables.
You need to turn on "Show items with no data " for column in Axis.

Solution1.PNGSolution2.PNGSolution3.PNG

Thanks !!

filipe197 Frequent Visitor
Frequent Visitor

Re: Display in axis X of a bar chart all months even those with no data yet

@prateekraina thanks a lot for your help!! Smiley Wink

prateekraina New Contributor
New Contributor

Re: Display in axis X of a bar chart all months even those with no data yet

Hi @flipe197,

Please like the post also if you are satisfied with my answer Smiley Happy

Prateek Raina