Forum Discussion
Helper IIIGroup Columns Based on Category and Make Table
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.
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.
5 Replies
- vanessafvg
Community Champion
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.
sheap069Here 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
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.