Forum Discussion
Solved
Using SWITCH with CALCULATE?
I'm new to Power BI so I apologise in advance if there's something obvious that I've missed. I have a couple of measures which sum values within a specific date range, to allow comparing between ...
I've cracked it. The solution was to add Fiscal year to the "Legend" of the clustered column chart. This then has the result I wanted.
I was able to make some progress, I created calculated measures which added together the two half-hours which represent each hour, and was able to use these in a field parameter, which produced the following:
However, I want to be able to have bars for different years side-by-side, ideally selectable using another slicer. And these are not calendar years but financial/academic years, i.e. they run from September to August. Not sure how I can accomplish this?