Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |