Forum Discussion

sabilahmed's avatar
sabilahmed
Icon for Resolver I rankResolver I
3 years ago

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

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 c...
Need Help
Hei_aQing's avatar
Hei_aQing
Icon for Helper I rankHelper I
3 years ago

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.