cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
DeepDive Member
Member

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

Accepted Solutions
Super User
Super User

Re: I want to create dynamic group table in power bi

@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
Super User
Super User

Re: I want to create dynamic group table in power bi

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?

DeepDive Member
Member

Re: I want to create dynamic group table in power bi

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

Super User
Super User

Re: I want to create dynamic group table in power bi

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/
Super User
Super User

Re: I want to create dynamic group table in power bi

@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

Super User
Super User

Re: I want to create dynamic group table in power bi

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/
DeepDive Member
Member

Re: I want to create dynamic group table in power bi

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

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 240 members 2,887 guests
Please welcome our newest community members: