I've been using charticulator to illustrate P&L numbers in a Sankey chart (see picture attached). However, I ran into an issue which I haven't been able to solve.
In the chart, I want the different rectangles in blue, green and red to be of absolute relative size to each other to illustrate the size of each "type" ("total revenue", "gross profit", "EBIT" etc). However, since some of the rectangles have negative numbers, these rectangles become very small which results in for example "Operating items" being very big relative to the numeric size. What I mean is, it doesn't make sense that for example "Other operating items" is almost as big as "Internal capitalized development" when thinking in absolute numbers. And it doesn't make sense visually that "Other OPEX" is very small compared to the absolute number 1092.
Is there a way to make the size of the rectangles to be related to the absolute number of the "Account amount" column? So that for example "Other OPEX" is slightly bigger than "Advertising revenue" even though it's a negative number?
I'm using the "Account Amount" column to control the length of the blue/red/green rectangles.
I have already tried to transform the "Account Amount" numbers to absolute numbers in Power BI but this makes the summarizing wrong so I need another solution. The best solution would be to have a checkbox in charticulator where you can choose to use absolute numbers or not (see example picture attached).
Hi,
I've been using charticulator to illustrate P&L numbers in a Sankey chart (see picture attached). However, I ran into an issue which I haven't been able to solve.
In the chart, I want the different rectangles in blue, green and red to be of absolute relative size to each other to illustrate the size of each "type" ("total revenue", "gross profit", "EBIT" etc). However, since some of the rectangles have negative numbers, these rectangles become very small which results in for example "Operating items" being very big relative to the numeric size. What I mean is, it doesn't make sense that for example "Other operating items" is almost as big as "Internal capitalized development" when thinking in absolute numbers. And it doesn't make sense visually that "Other OPEX" is very small compared to the absolute number 1092.
Is there a way to make the size of the rectangles to be related to the absolute number of the "Account amount" column? So that for example "Other OPEX" is slightly bigger than "Advertising revenue" even though it's a negative number?
I'm using the "Account Amount" column to control the length of the blue/red/green rectangles.
I have already tried to transform the "Account Amount" numbers to absolute numbers in Power BI but this makes the summarizing wrong so I need another solution. The best solution would be to have a checkbox in charticulator where you can choose to use absolute numbers or not (see example picture attached).
I have attached the example data in excel for reference. I used this tutorial when building out the chart: https://www.youtube.com/watch?v=K9uQD561F6Q&list=PLZU8y_ahnNiXWaoI6y0CPf2sCIVIzBXAK&index=3
Does anyone have a solution for this, or would it be possible to add the checkbox (see attached picture) to charticulator?
Thank you!