cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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 IV
Super User IV

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

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

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

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

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
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors