Combine data from different dimensions / tables

[Anonymous]

Hello all,

the screenshot shows the year-to-date comparison of sales for three different tables / dimensions (gender, agegroup, duration). I would like to combine the data from these different tables in order to have one common new table.

As result I would like to create a new bar chart with all possible values from these tables (sorted from best to worst), e.g. 

13 - 24m: 28,6%

51+ y: 8,6%

36 - 50y: 7,1%

female: 6,6%

.....

0 - 17y: -23,0%

How can this be done in Power BI? Thank you for your support!

Best regards

FF

[TomMartens]

Hey,

basically this is not possible as you different columns (neglecting the different tables aspect), and basically all the visuals are creating their axis content from one column.

But, maybe the newly introduced Key Influencer visual can provide something that similar to what you are looking for: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers

Regards,

Tom

[Anonymous]

Hi Tom,

thank you very much for your quick response. This new visual looks interesting but it does not help me as I would like to explain year-to-date comparisons for sales and the "key influencer" does not support measures.

Kind regards

FF

[TomMartens]

Hey,

I see, I think that measures will be supported sometime in the future. So, you may want to try it out now and then again.

Regards,

Tom