All values on X-Axis irrespective of presence of Data

[PowerGuy]

Hi,

I have a dimesnion having Months(Jan to Dec), which I am joining to the Fact table where I have only data for few months (Feb,Mar,Sep,Dec). When, I am plotting over Bar chart; I am getting a bar chart with only 4 months on X-Axis. However, I am need all 12 months on X-Axis irrespective of presence of data or not. How can I achieve this?

[v-lili6-msft · Accepted solution]

hi, @PowerGuy

After my test, you could right-click field on X-Axis and then select Show items with no data

Result;

beforeafter

Best Regards,

Lin

[PowerGuy]

Thank you Lin

[Sansudhi8]

Hey Hi, 

See the attached file. Sorry i'm not a expert. 

PBI