% RT in PowerBI chart form

[samnaw]

Hello:

I have the following data in PBI:

I would like to make a chart in PBI that does %RT. Like this but in a chart:

Whatever chart that I choose, the option that is available to me is %GT. How can I make a chart that is similar to below that I was able to do in excel:

Thanks, 

Sam

[Anonymous · Accepted solution]

Hi @samnaw 

You can try measure and stacked column chart or build a 100%Stacked column chart directly.

Table:

Measure:

%RT = 
VAR _TOTAL = SUMX(FILTER(ALL('Table') ,'Table'[Name]=MAX('Table'[Name])),'Table'[Sales_CY])
RETURN
DIVIDE(SUM('Table'[Sales_CY]),_TOTAL)

Result:

You can download the pbix file from this link: % RT in PowerBI chart form

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.