Forum Discussion

BobPierre's avatar
BobPierre
Frequent Visitor
8 years ago

STACKED CHART

Good day good people. I am new to Power BI. I have a set of data that I want to display like this: To display Percentage of column total.   The excel is the way the data loaded into Power Bi looks...
v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
8 years ago

Hi BobPierre,

Based on my test, you can refer to below steps:

1.I have entered some sample data like the picture below:

2.Create a measure.

MeasureA = (CALCULATE(SUM(Table1[Value]),FILTER('Table1','Table1'[Compliance Rate]=MAX('Table1'[Compliance Rate])&&'Table1'[Transpoter]=MAX('Table1'[Transpoter]))))/CALCULATE(SUM(Table1[Value]),FILTER(ALL('Table1'),'Table1'[Transpoter]=MAX('Table1'[Transpoter])))

3.Create a Stacked column chart and add the related field. Now you can see the correct result.

 

You can also download the PBIX file to have a view.

https://www.dropbox.com/s/ew4wb604joyxzeb/STACKED%20CHART.pbix?dl=0

 

Regards,

Daniel He