How to Show months within the next 6 months in Bar Graph

[blockobito]

How to Show months within the next 6 months in Bar Graph even without data on excel?

Barchart Count for Example 

October 2022  - 300 

November 2022 - 300

December 2022 - 250

January 2023 - 100

February  2023 -  0 

March 2023 - 0 

When i create a bargraph it only shows October to January. Since February March has no data or its not on the excel. 

[v-jayw-msft · Accepted solution]

Hi @blockobito ,

Step1: Create a calendar table that contains all dates you need.

calendar = calendar(startdate,enddate)

CALENDAR function (DAX) - DAX | Microsoft Learn

Step2:

Create a relationship between fact table and calendar table.

Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn

Step3:

Use calendar date as x-axis and enable the show items with no date feature.

Show items with no data in Power BI - Power BI | Microsoft Learn

Step4:

Set relative date filter for the visual.

Use a relative date slicer or filter in Power BI - Power BI | Microsoft Learn

Best Regards,

Jay

[Shaurya]

Hi @blockobito,

You should the month field from your date table instead of the values table. Make sure you have a many to one single directional filter from 'Values' to 'Date'. Then choose the range to be shown and you should be able to see months without data.

Did I answer your question? Mark this post as a solution if I did!
Consider taking a look at my blog: Forecast Period - Previous Forecasts