Unable to find visual to show total amount with percentages

[darshaningale]

I have data like this 

End Customer	SALES_AMOUNT	_ Discount	_ Total minus discount
Customer 1	5601054	30%	70%
Customer 2	5349214	30%	70%
Customer 3	4321680	29%	71%
Customer 4	3381914	30%	70%
Customer 5	3027728	38%	62%
Customer 6	2972262	25%	75%
Customer 7	2751788	44%	56%

I want to build a graph like the below.

Green is the discount. Grey is the 4th percentage in the above table. On top is the total sales.

[v-luwang-msft · Accepted solution]

Hi @darshaningale ，

What you want to achieve is currently not possible in PowerBI Desktop, you can try the following alternatives.

Solution 1, Stacked column chart（povit the column : _Discount ,_Total minus discount),and add  Total sales amount to tooltips,you could sort by Total sales amount)

Soultuion2, Line and stacked column chart:

1)Use line graphs to show percentages,

configure like below:

2)Use line graphs to show Total sales amount:

configure like below:

similar case refer:

https://community.powerbi.com/t5/Desktop/Stacked-column-chart-with-segment-percentage/td-p/2219123 

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[Watsky]

Hey @darshaningale ,

How about this? 

I used 100% Stacked Column Chart.

Set my Axis to customer and sales amount and values to discount and total minus discount.

Which gave me the chart with just the customer on it. Then I exapanded the hierarchy:

Result:

[darshaningale]

I do not need 100% stacked column. The bars would be sorted based on Total sales amount and not percentage.