Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

% 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 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

 

 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    5 years ago

    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. 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.