100% Stacked Column Chart by Percentage

[harirao]

Hello All,

I want to create 100% Stacked Column Chart, but unable to include more than one measure in that chart.
Below table i have considered column total and for Stacked column chart its % of Grant total

Eg of one measure calculation for above mentioned column.

> 6 weeks = IF(ISBLANK(CALCULATE(DISTINCTCOUNT(tbl_DEP3_Big_Deal_Perf_Data[OpportunityId]), FILTER(tbl_DEP3_Big_Deal_Perf_Data, tbl_DEP3_Big_Deal_Perf_Data[actual_visibility_weeks]>=6))),0,

CALCULATE(DISTINCTCOUNT(tbl_DEP3_Big_Deal_Perf_Data[OpportunityId]), FILTER(tbl_DEP3_Big_Deal_Perf_Data, tbl_DEP3_Big_Deal_Perf_Data[actual_visibility_weeks]>=6)))

>6wk = sumx(DISTINCT(tbl_DEP3_Big_Deal_Perf_Data[Delivery Priority Code]),[> 6 weeks])

I am looking visualization as below 

Please let me know if you need further inputs from my end.

Thank you

Regards,

[v-jayw-msft · Accepted solution]

Hi @harirao ,

Currently 100% Stacked Column Chart is not supported for legend with multiple values.

You could submit this idea through below link.

https://ideas.powerbi.com/ideas/

Best Regards,

Jay

[amitchandak]

@harirao , refer

https://ideas.powerbi.com/ideas/idea/?ideaid=db76a137-4324-4d6c-b5c5-cb85f9b6950a
https://community.powerbi.com/t5/Desktop/Double-Stacked-Column-Chart-Combination-of-Stacked-and-Colu...
https://www.defteam.com/stacked-clustered-bar-chart/