Need help in creating a visual

[Anonymous]

Dear all,

I am trying to generate a graph that is similar to 100% stacked clumn chart, however, the width of each column should correspond to the percentage of the column to the total value.

For example, if we have a dataset like

	A	B
C	1	5
D	3	4

then column A should take up (1+3)/(1+3+5+4) = 31% of the x-axis (rounded up), clumn B should take up 69% of the x-axis.
For column A, value of C should be 1/(1+3) = 25%, value of D should be 75%.

Similarly, for column B, value of C should be 5/(5+4) = 56%, value of D should be 4/(5+4) = 44%.

Does anyone have any idea about what visual I should use and how can I generate such a visual?
Thanks in advance!

[lkalawski · Accepted solution]

Hi @Anonymous ,

To do this, please use marimekko chart. 

You can find the details here: Power BI - Create a Marimekko chart

Memorable Member | Former Super User If I helped, please accept the solution and give kudos!  Linkedin

[Anonymous]

Hi @lkalawski 
Thanks for your response! That's exactly what I'm looking for!