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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
netanel
Post Prodigy
Post Prodigy

Group reorganization

I have two columns that come from the system
product and sub-product
I want to organize and arrange a product so that it includes more sub-product

I know the answer is in Query but I can't find it
I don't want to use data groups so as not to create another column

 








Did I answer your question?
Mark my post as a solution!
Appreciate your Kudos!

Connect on Linkedin
linkedin.com/in/netanel-shriki
1 ACCEPTED SOLUTION

@SergioSilvaPT 

Yes, I thought about it, but I don't want to add Excel, because it needs constant maintenance and updating according to changes

 

I found a solution!
I multiply the sheet in Query and create a reference between the columns I want
So they will be updated every time from the system
But in the sheet I duplicated I create the updated groups according to what I want

work like magic (:

 

Thanks for your help!








Did I answer your question?
Mark my post as a solution!
Appreciate your Kudos!

Connect on Linkedin
linkedin.com/in/netanel-shriki

View solution in original post

5 REPLIES 5
SergioSilvaPT
Resolver V
Resolver V

Hi @netanel,

 

I would like to try to help you, but i didn't uderstand your question, can you try to elaborate a little more? Or give some pratical example?

 

Regards,
Sérgio Silva

If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Check out my blog for tips and tricks about Power BI: https://pbibits.wordpress.com/

Regards,
Sérgio Silva

If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Check out my blog for tips and tricks about Power BI: https://pbibits.wordpress.com/

Hi , @SergioSilvaPT 

 

I didn't list or share a file because I felt it was simple
But I will try to explain a little more
in the attached picture
There is a product group column "group tolls"
and a "toll" product column
The columns come from the systems like this and I have no option to change the group.
But when it comes to the dashboard
I would like to create other groups based on the same columns
For example, "Autopsy" which appears under the "toll" column and belongs to "Yogurt - plain"
will move to be under "Bok choy - baby"

I have more than 20 sets of products and more than 1M products








Did I answer your question?
Mark my post as a solution!
Appreciate your Kudos!

Connect on Linkedin
linkedin.com/in/netanel-shriki

@netanel i think that the best approach is to create a file, for example, an excell with your new groups and connect it to the existing table.

 

This will facilitate future updates in the groups, because you will only need to change in the excel and refresh the dataset.

 

Steps:

  1. Create the excel with the new combinations for the groups (must ensure that the names in the toll column are the same as the original table);
  2. Load the excel into the model;
  3. Connect both tables by toll column, with this new table filtering the existing table.

 

Regards,
Sérgio Silva

If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Check out my blog for tips and tricks about Power BI: https://pbibits.wordpress.com/

@SergioSilvaPT 

Yes, I thought about it, but I don't want to add Excel, because it needs constant maintenance and updating according to changes

 

I found a solution!
I multiply the sheet in Query and create a reference between the columns I want
So they will be updated every time from the system
But in the sheet I duplicated I create the updated groups according to what I want

work like magic (:

 

Thanks for your help!








Did I answer your question?
Mark my post as a solution!
Appreciate your Kudos!

Connect on Linkedin
linkedin.com/in/netanel-shriki

No problem mate. Glad it's solved!

 

Regards,
Sérgio Silva

If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Check out my blog for tips and tricks about Power BI: https://pbibits.wordpress.com/

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors