Forum Discussion
Add calculated column to matrix table display
I have seen how to put the values as a row, but I am not able to add the column with the calculated percentages, and putting them as a value would not be a solution, since it would have a table of more than 100 rows, and the visualization would be complicated.
You are conflating a number of separate concepts here. The recommended action here is to create a measure with the percentage calculation, and then to add the measure to the values.
Hello
Thank you for your answer, but in Power BI I already have as a measure both the absolute value and the percentages, and as columns the dimensions.
The problem is that I need the percentages in column and the absolute values as rows, and this is where I don't know how to do it.
When I put values as rows, I can't add the percentages as columns.
I hope you can help me.
Thank you!
You have Estados as rows and Categorias as columns. Both the absolute and the percentage are in the values area of the matrix visual.
Hello
First of all, thank you for your reply.
I think I'm not explaining myself well...
As values I have the total of records that is in each state and the percentage that represents, and as dimensions, the different categories.
but the presentation I need to make is to put the absolute values of each state's record totals as rows, but the % of these records as a column.
When I tell the parent table that I want the values as rows, the resulting table is:
But what I would need would be this:
Thank you
