Forum Discussion

ocifci's avatar
ocifci
Frequent Visitor
9 years ago
Solved

Purchase price grouping

Hi all! I'm a beginner who's very confused about how I would go about achieving the below and hope you can help :)   I have a Property Purchase Price column and would like to create a bar chart tha...
Need Help
  • TomMartens's avatar
    TomMartens
    9 years ago

    Hey,

     

    create a column that sorts the "Purchase Price" into buckets like so

     

    Purchase Price Buckets = 
SWITCH(
    TRUE()
    ,'yourtable'[Purchase Price] < 1000000, "<1m"
    ,'yourtable'[Purchase Price] >= 1000000 && 'yourtable'[Purchase Price] <= 3000000, " 1m - 3m"
,...
    , "> 10m")

    Then you can use this column as xaxis. Use the property as value and the aggregation function count.

     

    Hope this gets you started

     

    Regards

TomMartens's avatar
TomMartens
Super User
9 years ago

Hey,

 

create a column that sorts the "Purchase Price" into buckets like so

 

Purchase Price Buckets = 
SWITCH(
    TRUE()
    ,'yourtable'[Purchase Price] < 1000000, "<1m"
    ,'yourtable'[Purchase Price] >= 1000000 && 'yourtable'[Purchase Price] <= 3000000, " 1m - 3m"
,...
    , "> 10m")

Then you can use this column as xaxis. Use the property as value and the aggregation function count.

 

Hope this gets you started

 

Regards

ocifci's avatar
ocifci
Frequent Visitor
9 years ago

Hi Tom

 

Thank you for this. It worked perfectly!

 

Many thanks and have a great day! :)

 

OC

  • TomMartens's avatar
    TomMartens
    Super User
    9 years ago

    Welcome in the wonderful and sometimes mysterious world of Power BI

     

    Regards