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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
DeepDive
Helper IV
Helper IV

I want to create dynamic group table in power bi

Hello Experts,

I want to create dynamic group table basis my input. For example if i enter = 10, i get below table .. no. of rows are static, in this example .. rows are 15 :Capture_Ask.PNG

 

1 ACCEPTED SOLUTION

@Ashish_Mathur 

Could we do something with a couple of input tables like in the attached?  I got it to calc the low end and high end based on muliplying the group row * the selected segment.

DynamicSegments.jpg

@DeepDive 

What are you wanting to put into the groups?  # of customers based on some other measure?  What are the possible segment steps?  I put my example at 1, 2, 3, 4, 5, 10, 15, 20, 25, 50.

View solution in original post

6 REPLIES 6
Cmcmahan
Resident Rockstar
Resident Rockstar

How is the input value determined? Also, how do you know how many S.No's there are going to be? Is it always 15?

 

Do you need this as a table, or just an output value? How are you trying to use it?

I have sales data, now my requirement is that if i enter segment range like 10, then first it creates groups like below (total number of groups will remain 15 always ...) , now under groups I want to show the count customers falling...

here I am unable to create dynamic range :

 

List.png

Hi,

I cannot create the Groups based on a user defined interval.  However, if we can treat the Groups as a static input, i can segment the customers in the groups.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

@Ashish_Mathur 

Could we do something with a couple of input tables like in the attached?  I got it to calc the low end and high end based on muliplying the group row * the selected segment.

DynamicSegments.jpg

@DeepDive 

What are you wanting to put into the groups?  # of customers based on some other measure?  What are the possible segment steps?  I put my example at 1, 2, 3, 4, 5, 10, 15, 20, 25, 50.

Thank you  @jdbuchanan71 , have the same thougts but unable to implement.... thanks a lot again

Hi,

May be - not sure as yet.  Will need some data to work with.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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