Forum Discussion
% RT in PowerBI chart form
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 availabl...
Hi Anonymous
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.
Hi Anonymous
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.