Converting table matrix to column chart - % row total

[Turquesa]

Hi Community,

I have a matrix table in Power BI. Here I have a list of buckets (sales buckets) and in the matrix table I am showing the values by month as a % of row total.

I have also added a column with the same data but I am unable to display the % (of row total) rather than the sale numbers....

Could you please point me in the right direction?!

Thanks!

[v-jingzhan-msft · Accepted solution]

Hi @Turquesa 

You can try the 100% Stacked column chart. Put Month on X-axis and Sales bucket on Legend. Put sales on Y-axis. 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[adudani]

hi @Turquesa 

does this help - Calculate Percentage of Total in Power Query (youtube.com) ?

if not , please provide a sample input and output masking sensitive data.