Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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

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.

 





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
vanessafvg
Super User
Super User

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.

 





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Thanks a lot ! 

zakariaellaoui
Regular Visitor

Anyone please ?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.