Forum Discussion

zakariaellaoui's avatar
zakariaellaoui
Regular Visitor
9 years ago
Solved

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

 

  • vanessafvg's avatar
    vanessafvg
    9 years ago

    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.

     

3 Replies