Grouping by levels

[AH2022]

Hi All,
I have a visual and need to display the values by groups ( payments and I need to show 1k-5k, 5k-10k etc).

I have scoured the web looking for an answer on this topic and I tried different solutions, with no success.

I am wondering if there is a possibility to use grouping ( as in Pivot Tables, Excel.).

Thank You!

[AlexisOlson]

Try searching for "static segmentation" and you should find plenty of relevant results.

Here's one particularly relevant article:

https://www.daxpatterns.com/static-segmentation/

[AH2022 · Accepted solution]

Thank you @alexisw  I used the link you suggested and this link for a free video : Dynamic Banding & Segmenting Example In Power BI Using DAX - YouTube

[Shaurya]

Hi @AH2022,

You can create a conditional column that assigns values for your categories like 1k-5k, 5k-10k and so on. Then SUMMARIZE table to show the aggregate values in the category.

Did I answer your question? Mark this post as a solution if I did!
Consider taking a look at my blog: Forecast Period - Previous Forecasts

[AH2022]

Thank you @Shaurya