Forum Discussion
Grouping Categories on visual
Hi there
I was wondering if there is a way to show the data below as 1,2,3,4 and 5&up. I know I could create a column but i want to know if there is snother way
6 Replies
- BA_Pete
Super User
Hi Anonymous ,
You can use Grouping in your field list.
In the field list on the right of the report view, right-click on your [Intentos] field and select New group:
In the dialogue that opens, multi-select all the values you want in one group on the left, then hit Group. Do this for each combination of values you want in each group:
Once you've done that, you can use this group field instead of your normal field for grouped axes:
Pete
Hi BA_Pete I had forgot about that thanks!
but doing so will create a new column right?- BA_Pete
Anonymous ,
Yes, it does, no way around that I'm afraid. Just a more intuitive way to do it than writing a conditional column or similar.
FWIW, my preference would always be to create these types of grouping fields as a column in Power Query beforehand anyway. Pushes that work that must be done *somewhere* away from the model and end-user memory.
Pete
- Greg_Deckler
Community Champion
Anonymous Using groups/binning
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-and-binning
- BA_Pete
Sorry Greg_Deckler , was responding as you posted 🙂
- Greg_Deckler
