Forum Discussion
Grouping by levels
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!
Thank you Anonymous I used the link you suggested and this link for a free video : Dynamic Banding & Segmenting Example In Power BI Using DAX - YouTube
4 Replies
- Shaurya
Memorable Member
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 - AlexisOlson
Super User
Try searching for "static segmentation" and you should find plenty of relevant results.
Here's one particularly relevant article:
- AH2022
Helper II
Thank you Anonymous I used the link you suggested and this link for a free video : Dynamic Banding & Segmenting Example In Power BI Using DAX - YouTube