Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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
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
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
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |