Forum Discussion
Need help in creating a visual
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!
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
2 Replies
- lkalawskiResident Rockstar
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- AnonymousNot applicable
Hi lkalawski
Thanks for your response! That's exactly what I'm looking for!