Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
sheap069
Helper III
Helper III

Group Columns Based on Category and Make Table

Hello,

 

I have data in the following format: 

 

sheap069_0-1600276747747.png

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

 

 Category 1Category 2
Count 110080
Count 25030
Percentage 150%38%
Count 34040
Percentage 340%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.

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





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




View solution in original post

5 REPLIES 5
vanessafvg
Super User
Super User

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.




If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




@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

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.





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




@vanessafvg Hi,

 

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

Thanks.

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





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.