Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I'm building a Line and Stacked Column Chart, in which the X-Axis represents months in 2022. Whereas the Line Y-Axis represents Total Employee Capacity (i.e. Work hours x Number of working days in each month), and the Column Y-Axis represents the Actual Timesheet Hours reported.
At first, when I added just the Capacity Line, everything looks fine:
Then, after I added the Actual Timesheet Hours reported, the Capacity line shows up just to March. (Because we only have Actuals data just up to March).
I want to keep the Capacity line showing all the way until December.
Please kindly advice how to enable this. Thank you very much.
Regards,
Nichanal
Solved! Go to Solution.
Yes I do have a separate table that contains just month number and month name.
Then the Capacity table and the Actuals table both relate to this month table.
But I just got it solved now! I need to click the arrow next to the X Axis field and click "Show items with no data"
Thank you for your help Allurean.
Regards,
Nichanal
Hi @nichanallseg ,
here is Stacked Column chart with Non Continuous Line Chart which will help you to get the stacked chart with all the values of line chart
Stacked Column Chart with Non-Continuous Line Chart, PBIVizEdit.com
Stacked Column Chart with Non-Continuous Line Chart, PBIVizEdit.com
Download link for the custom visual file in this page,
https://pbivizedit.com/gallery/stacked-column-chart-with-non-continuous-lines
This was made with our Custom Visual creator tool PBIVizEdit.com. With this tool,
Give this a shot and let us know if you face any problem/errors.
You can use the editor to modify your visual further (some modifications cannot be done in Power BI window and have to be in editor).
Thanks,
Team PBIVizEdit
Hi, @nichanallseg
Is Capacity coming from different table than Actuals? You can check this if you use common date dimension (calendar table) i.e. your X-Axis for start / end dates there and extend Max date to come from Capacity table.
Proud to be a Super User!
Yes I do have a separate table that contains just month number and month name.
Then the Capacity table and the Actuals table both relate to this month table.
But I just got it solved now! I need to click the arrow next to the X Axis field and click "Show items with no data"
Thank you for your help Allurean.
Regards,
Nichanal
Yes I have the Capacity data up until December. You can see the first image I attached that it showed all the way.
Regards,
Nichanal
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
90 | |
67 | |
62 | |
53 |