The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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!
Solved! Go to 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! |
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! |