Forum Discussion

YevD's avatar
YevD
Helper I
5 years ago
Solved

Creating buckets/bins based on value ranges

Hello and thank you taking a look at this.   I am looking for a way to put a range of $ values into custom bins, which I could then use in a number of combo charts with other variables. As I unders...
Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, YevD 

I am not sure if I understood your question correctly.

Please try to create a grouping table something like below, which is separated and not connected with other tables in the model.

The values can be always segmented into the group by writing a DAX measure.

 

 

If you have a sample pbix file, please share a link here, then I can try to look into it to come up with more accurate solutions.

 

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

  • YevD's avatar
    YevD
    Helper I
    5 years ago

    Hi Jihwan_Kim, would you be able to help out with the DAX measure or the claculated column?

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Super User
      5 years ago

      Hi, YevD 

      Thank you for your feedback.

      Please share your sample pbix file's link.

      I still suggest having a separate grouping table, but I want to see the sample pbix file.

      Thanks.