Forum Discussion
Group by a Specific Data Element in Power BI
Hi, I have a simple Table in Power BI, and I need to Group the data based on this one data element shown below; So Agency is the group, and the data is listed one level below the Agencies. Any group...
...and what is your question?
You have your dimension "Agency" in your data model.
Bring it into your Matrix visual and add some measures etc. then you will have your grouping.Hi Anonymous ,
You can create a matrix visual with the below Fields settings, and toggle off the option "Stepped layout".
Toggle off the option "Stepped layout"
Best Regards
sergej_og
Super User
Super UserThis is a property (difference) for these specific visual types.
A table gives you plain all data you want to see.
Matrix groups data.
It is an another kind of visualization.
What about using Matrix and switching off all subtotals/totals?
A kind workaround 🤔
Yeah, unfortunately, that doesn't do the trick and I'm not sure what you are referring to Switching off subtotals/totals. Thanks for your time.