Actuals (current) vs Comparison Scenario - Cluster column chart - Tabular cube (Analysis Services)

[sabilahmed]

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?

Many thanks!

[Hei_aQing]

hi @sabilahmed ,

--The issue I have is that Current and Comparison scenario exist in separate tables and I cannot bring 2 fields into the "legend" section.

The legend allows only one field to be dragged in. Try creating two measures for two slicers and use the cluster bar chart.