How to get the % of total values in columns and a total value in the totals in matrix (Please refer

[naren_palmure]

Hi All,

In power bi I am trying to build the visualization in matrix, but do not see options to achieve the same.

Can someone help with the approach?

[naren_palmure]

@Anonymousthank you for your kind reply,

So I am having the below data set, which I am trying to get the sales by every month for every category, and in the rows the % values every month of the sum total for that category
raw data as below:

Total = Sum(Sales)

Montly % Values = DIVIDE(SUM([Sales]), CALCULATE([SUM([Sales]), ALL([Category], [Month])])) * 100

[Anonymous]

Hi @naren_palmure ,

In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.