Forum Discussion
Grouping Categories on visual
Super UserHi 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