Group Columns Based on Category and Make Table

[sheap069]

Hello,

I have data in the following format: 

And would like to create a table in my report in the following format:

	Category 1	Category 2
Count 1	100	80
Count 2	50	30
Percentage 1	50%	38%
Count 3	40	40
Percentage 3	40%	50%

And this would change based on the slicer selection of the ID. 

I am unsure of how to go about this. 

Thank you very much.

[vanessafvg]

can you provide your data, the image you provided in text form and then i can put a power bi together to show you how.

[sheap069]

@vanessafvg 

Here it is:

ID	Category 1 Count 1	Category 2 Count 1	Category 1 Count 2	Category 2 Count 2	Category 1 Percentage 1	Category 2 Percentage 1	Category 1 Count 3	Category 2 Count 3	Category 1 Percentage 2	Category 2 Percentage 2
1	100	80	50	30	50.00%	38.00%	40	40	40.00%	50.00%
2	100	40	60	20	60%	50%	20	10	10%	10%
3	60	50	30	25	50%	50%	20	20	90%	90%

Thanks again

[vanessafvg · Accepted solution]

Hello

see attached. All this is done in the energy consultation.

1. Take off the data

2. Then divide the columns.

obviously % sign will not apply when you have counts to the same extent, because you cannot mix data types to the same extent.

[sheap069]

@vanessafvg Hi,

Perfect, thank you. I managed to get the table the way I want it. 

Thanks.

[vanessafvg]

hi you accepted the solution then you changed your mind, would appreciate if you could remark it as the solution or provide thte solution.