Forum Discussion
Add calculated column to matrix table display
Hello
I have a visualization of an array table, in which I need to have the values as a row (I have more than 50 calculated values and about 12 columns of categories), but in a column next to the values I would need to have some calculated percentages.
In excel it would be something like this:
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.
Does anyone know if it is possible to make this visualization that I need?
Thanks a lot!
7 Replies
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.
