Forum Discussion
AdministratorAdd 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
- lbendlin
Super User
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.
Syndicate_AdminHello
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!
- lbendlin
You have Estados as rows and Categorias as columns. Both the absolute and the percentage are in the values area of the matrix visual.
