Customized mekko chart

[timtack]

Hello Community,

i am searching for a solution. My requirements are a horizontal orientated mekko chart  where i can use conditional formating for the data colors. In following picture you see my first requirement:

This picture ist from the xViz-Mekko Chart. However i can't use their chart, because they don't support conditional formatting for the data color. Neither does the mekko chart 3.2.1. from microsoft and their chart is vertical orientated.

The following picture is the staked bar chart in PBI with my individual x-Axis. But i also need that the y-axis with of the bars is conditional on the sales volume to transform it to a mekko chart i need.

Is there a possibility to build my own mekko chart to fit my requirements? Or is there any other possibility?

[timtack]

Thank you very much for your answer! I'll try that now.

Is there a possibility to apply a y-axis width for the bars? Because it is important for us to compare the charts intuitively. This is how it looks like at the moment: (all staked bar charts)

[AmiraBedh]

Power BI does not have a built-in option to directly apply a y-axis width for the bars in a bar chart or column chart. The width of the bars in these charts is automatically determined by the space available on the x-axis and the number of categories.

[AmiraBedh]

Unfortunately, Power BI doesn't have a built-in option to create a Mekko chart directly, but you can use the following workaround:

Create a new calculated column in your data model to calculate the percentage of each category.

Use the DAX formula to calculate the percentage, like:

[Percentage] = [Value] / SUM([Value])

Now, use the "Percentage" column in your chart instead of the "Value" column. The 100% Stacked Bar Chart will represent the proportions of each category.

To adjust the width of the bars, you can use a stacked column chart instead of a 100% stacked bar chart. Create a new calculated column to calculate the starting point of each category. For example, if you want a bar representing 20% to start at 40% on the x-axis, the formula could be:

[StartingPoint] = 40% + SUMX(FILTER('YourTable', 'YourTable'[Category] < EARLIER('YourTable'[Category])), [Percentage])

Drag and drop the "StartingPoint" and "Percentage" columns into the Values box of the visualization pane and select the Stacked Column Chart icon from the drop-down list.