Forum Discussion

harirao's avatar
harirao
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

100% Stacked Column Chart by Percentage

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,

Need Help
Tips and Tricks

2 Replies