Andrew on 14 Jun 2019 21:56:24
We have the ability to Group tables and everything else within Query Editor. Even some grouping ability within Relationship view.
Currently the only sorting that occurs outside of the alphabet is your Measures tables go to the top.
Please add the ability to Group together Tables within the Report View of Desktop. It would be much easier to organize a data model that doesn't sort by alphabet no matter if it is a dimension, fact, or intermediate table.
- Comments (3)
RE: Group Tables in Report View
I'm surprised this doesn't have more votes! I'm working on a large shared dataset for project teams, and have a few dozen tables that I would love to be able to group into categories like "finance", "project", "schedule", "staff", etc. in the Fields panel view to make it easier for the team users to create reports off my curated dataset.
RE: Group Tables in Report View
Yes, this would be a significant improvement. Either allow us (as commented below) to carry over the table groups from the Power Query Editor view and or, allow us to create custom ones in Report view.
Dataflows and Datasets may be developed by different developers or under different meta schemas and so we could have to use different naming conventions at different levels.
Having the ability to group them the same or differently would be great for the long-range governance needs. Thanks
RE: Group Tables in Report View
Simply (optionally?) carrying through the PowerQuery groups into the table list and allowing the ability to collapse and expand a group would make the model far more readable, especially for shared data sets.