Line and stacked column chart, how to display all data

Hello,

I'm trying to create a report that compares our actual sales to our budgeted sales.

The total budget per month is plotted as a line in the line and column chart, while the actual sales of the different products are stacked columns.

What I would like to do, is to have the budget for all the months of the year present in the chart as a line, while the columns of the actual sales would show up as the sales are made.

Unfortunately for the months in the future, where there are no sales registered yet, the budget line disappears as well. I have tried use the "Show items with no data" on the shared axis, however that only makes the months without sales show up, not the budget for those months.

Is there a way to make this chart show the line values although there are not any corresponding column values?

Need Help

jda
10 years ago
Now I got it to work.

I updated to the latest verison of Power BI, and started from scratch by loading in the tables and creating the relationships.

Not sure what is different, but now it works:)

7 Replies

SamLester
Microsoft Employee
10 years ago
By default, I'm able to display the budget line even though there are no values in my sales column for upcoming years. Can you provide a screen shot that includes the values you're using for the visualization parameters?

Thanks,
Sam Lester (MSFT)
- jda
  Frequent Visitor
  10 years ago
  
  Here is one example of what it looks like. Since there are no sales past August, the budgets for the remaining months don't show up.
  - sdjensen
    Solution Sage
    10 years ago
    What happens is you change the visual to a column chart? I have seen some strange behaviours with combined line and column chart in the latest release of PBI Desktop.