I have a tabular cube set up where I have current scenario (actuals) and comparison scenario (previous years). Both are seperate slicers. I can slice dynamically to choose which scenarios I want to compare. see below:
I am trying to build a cluser column chart whereby when i slice dynamically between current and comparison scenario they are displayed as 2 columns/ bars per month.
The issue I have is that Current and Comparison scenario exist in separate tables and I cannot bring 2 fields into the "legend" section.
These are the 2 separate tables:
Is there a way I can build this cluser column chart or is there an alternative visual I could use?
As this is a Tabular cube live connection (Analysis Services), I cannot use calcuayted columns. Do I need to manipulate the data at the SQL level?