Add calculated column to matrix table display

[Syndicate_Admin]

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!

[lbendlin]

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_Admin]

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!

[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.

[Syndicate_Admin]

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

[V-lianl-msft]

Hi @Syndicate_Admin ,

Please provide some sample data or sample pbix so that we can do more tests:

https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-... 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Syndicate_Admin]

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!

[lbendlin]

Thank you for providing the pbix.

I would recommend that you rethink your approach to this.  General advice is to avoid scroll bars on your visuals, especially horizontal scroll bars.  Your visual has three (!!) scroll bars - not only is your visual too small for the amount of data you have, but you also used a custom page size.  This is guaranteed to create a bad user experience.

Use multiple pages, think about using paginated reports, or even separate reports. Once you do that then your original issue might resolve itself too.