Skip to main content

Power BI

New

Grey out or hide tables that are unrelated in field list

Vote (2) Share
Greg Galloway's profile image

Greg Galloway on 26 Jan 2017 23:37:26

Let's say that I start a new report by adding the Inventory Quantity measure to a table. I get no indication in the field list that the Product and Warehouse tables are related to the measure in my table but that the Customer table is not. Please show some sort of indication of this such as greying out the unrelated tables or giving us a button which hides any unrelated tables. The biggest concern is that if I add Customer to my table, then the Inventory Quantity repeats since it's unrelated. This can cause confusion to users and performance problems.

Please do not prevent us from choosing unrelated tables as unrelated tables can impact the logic of DAX calculations in my measure.