Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
Solved! Go to 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.
Proud to be a Super User!
Proud to be a Super User!
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
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.
Proud to be a Super User!
hi you accepted the solution then you changed your mind, would appreciate if you could remark it as the solution or provide thte solution.
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
74 | |
63 | |
51 | |
47 |
User | Count |
---|---|
211 | |
85 | |
64 | |
59 | |
56 |