Forum Discussion
AdministratorAdd calculated column to matrix table display
AdministratorHello
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
Community SupportHi 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.
- 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
Super User
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.
