I have a Line and stacked column chart, with column data being dispalyed as MM-YYYY in the x axis and the y axis being GBP value. This is being generated by a SQL connection, for invoices.
With the Line in the chart, I have a different data source - being an Excel sheet showing 'Budget'. This has three columns within the data source; MM-YYYY, Order Type, and GBP Value.
The links for the two sources are MM-YYYY and Order Type.
On the first level visualization, it displays as expected.
However, now that I have added a drill down, when I drill down to the next level by selecting a single month, the visualization takes me to the Order Type level data. The GBP values show as expected within the columns, but the budget line doesn't appear linked to the Order type options, and remains the month budget, rather than the order type by month budget.
So if I have 5 order types, all with £1m budget for 03-2021 in the Excel file, the budget sums and shows as £5m for the first level, and then also in the drill down level. I am wanting the £5m summed for the first level, and then in the drill down I want it to recongise the month I've selected and have the line on the graph then split the summed budget into the order type level.
I've followed what I can with help articles and videos, but am stuck. Am new to Power BI.
Any help appreciated.
