Forum Discussion
Dynamic Line and Column Chart
Hi There, I want to use a slicer to choose Total Production (EA), or Energy Usage (MJ), or Total Production (KG). When I choose either one, x-axis is month and y-axis to the value. Please note t...
I think you could Unpivot the numeric columns in Power Query.
Write a couple of measures : One to sum the values for Target, one to sum the values for Actual.
Use those in the relevant y-axis field wells.
--
The month would go on the x-axis and the sorting would probably be the most challenging task. I would probably create a dimension table for month (including YTD and FY) with an additional sort order column, then use 'Sort by Column' feature. Create a relationship to Fact table.