Can I group dimensions into a single folder? Or best way to handle this?

[Don-Bot]

I have a model that will have a lot of dimensions.  I was wondering if there was a way to group dimensions into a single folder (like measures) or another way to organize them?

Thanks,

[v-pnaroju-msft]

Hi Don-Bot,

We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.

If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.

Thank you.

[v-pnaroju-msft]

Thank you, @d_m_LNK, @Ritaf1983, for your response.

Hi Don-Bot,

We would like to check if the solution provided by @d_m_LNK, @Ritaf1983 has resolved your issue. If you have found an alternative approach, we encourage you to share it with the community to assist others facing similar challenges.

If you found the response helpful, please mark it as the accepted solution and add kudos. This recognition benefits other members seeking solutions to similar queries.

Thank you.

[Ritaf1983 · Accepted solution]

Hi @Don-Bot 

You actually have two main ways to group or organize dimensions in Power BI:

1. Group tables in Power Query (PQ):
   If your dimensions come from multiple queries, you can group them logically in Power Query Editor by using folders (right-click > "New Group"). This helps keep your queries organized at the source level.

2.Using diagram layouts in the Model View:
In the Model view, you can manually arrange your tables and fields into logical layouts. For example, you can position related dimension tables together, resize them, and create a clean visual structure that makes it easier to navigate your schema. This doesn't change the data model itself but helps visually group related elements.

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-modeling-view

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[d_m_LNK]

The only grouping to do for Dimensions would be in Power Query to create foldered groupings there.  Outside of that the only foldering to do would be display folders within the tables themselves in Power BI.  The Measures "folder" is just a blank table usually with the columns hidden so it only sees the measures.