Combine and display data based on a set range

Hi BI101 

To create bins by sales sum you can add a  calculated column like :

Bins = if('Table'[Sales]>0 && 'Table'[Sales]<= 49999,"0-49,999",

if('Table'[Sales]>49999 && 'Table'[Sales]<= 100000,"50,000-99,999","100,000+"))

To sort the bins in the right order on visuals you can create a table with bins' names and sort order :

create a relationship between the tables :

Modify sort order :

 

create simple DAX for distinctount of quotes :

Quotes# = DISTINCTCOUNT('Table'[Quote id])

Put the data on the graph:

PBIX is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Hi BI101 
That is why I added a sort order column and a table :

You need it to sort the bins in the right order

And use the bins column from this "small" table on visuals 

More information about sorting by column:

https://www.techrepublic.com/article/how-to-sort-by-column-power-bi/

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly