Forum Discussion
Combine data from different dimensions / tables
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
3 Replies
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
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
