Change ranges value ?

[zakariaellaoui]

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

[vanessafvg · Accepted solution]

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.

[zakariaellaoui]

Thanks a lot ! 

[zakariaellaoui]

Anyone please ?