Grouping Categories on visual

[Anonymous]

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

[BA_Pete]

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

[Anonymous]

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]

@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]

@BA_Pete Don't sweat it! Your post is waaaayyyy better than mine! @Anonymous Use @BA_Pete 's post and mark it as the answer instead of mine if it solves your problem!!