Forum Discussion
Add calculated column to matrix table display
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
Hi Syndicate_Admin ,
Please provide some sample data or sample pbix so that we can do more tests:
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hello
Attached link to pbix with the matrix with values as rows, but as you will see the percentages appear below the absolute value, and what I need is that it appears next to the absolute value.
https://www.dropbox.com/s/raxjmzalxnftp27/Funnel%20Control%20de%20dades_TEST.pbix?dl=0
I hope you know some way to get it.
Thank you!
