Forum Discussion

timtack's avatar
timtack
Frequent Visitor
3 years ago

Customized mekko chart

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...
Need Help
AmiraBedh's avatar
AmiraBedh
Super User
3 years ago

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.