Jaap Olsthoorn on 12 Feb 2020 17:29:32
In our reports, we often hide the key columns on the many side of one-to-many relationships, because we do not want people to use these columns in their reports. However, despite hiding them, these columns still pop up in intellisense, confusing me and our users. It would be great to have the option to not show hidden columns in intellisense suggestions. I do think this should be optional, and not applied to everyone, because there can be other reasons to hide columns.
- Comments (1)
RE: Remove hidden columns from intelisense suggestions DAX
If this was implemented, this option would need to be available for each column. Within the same Data Model, you might have one column that you want to hide because it is on the "many" side of a one-to-many relationship (good for hiding in IntelliSense), and you might have another column that you want to hide because it contains numeric data and you want users to use it using measures and not the column directly (bad for hiding in IntelliSense because you would want it to appear when you are writing that measure).I think that it is better to just not have the option at all to hide columns in IntelliSense. That option would add more work than it saves.