cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
zakariaellaoui
Regular Visitor

Change ranges value ?

Hello Power BI Lovers ! 

 

I have a table with two columns : 

Salesman              Sales

Zak                        50$

Joseph                   100$

Fred                       32$

 

I want to be able to have a chart where I can see the number of salesman by specific ranges :  ' 0-50' and '51-101'...

The difficulty is that I want to be able to modify these "ranges" whenever I want, for example 0-50 => 1 - 49 instead. 

 

I tried to do this with measures, it worked, but I have more than 6 ranges and it can be confusing, can I store theses measures in a table for instance ? So it can be more clear for the users.

 

Thanks for your help ! 

Zakaria

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User I
Super User I

Re: Change ranges value ?

create the bands you want in a table.   So either new table in power query or dax and fill in the values you want to band on

then create a measure and link that to the banding.

 

here is the detail

 

http://exceleratorbi.com.au/banding-in-dax/

 

But im not sure that helps with change the values.

 


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!

View solution in original post

3 REPLIES 3
Highlighted
zakariaellaoui
Regular Visitor

Re: Change ranges value ?

Anyone please ?

Super User I
Super User I

Re: Change ranges value ?

create the bands you want in a table.   So either new table in power query or dax and fill in the values you want to band on

then create a measure and link that to the banding.

 

here is the detail

 

http://exceleratorbi.com.au/banding-in-dax/

 

But im not sure that helps with change the values.

 


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!

View solution in original post

zakariaellaoui
Regular Visitor

Re: Change ranges value ?

Thanks a lot ! 

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors