Skip to main content

Power BI

New

Apply Active/Inactive Relationships at the Report, Page, or Visual Level

Vote (2) Share
Simon's profile image

Simon on 14 Aug 2019 23:29:46

Managing models which contain multiple relationships between tables can be troublesome.

An example model may be:
Fact_Invoice[Delivery Date] -> Dim_Date[Date]
Fact_Invoice[Purchase Date] -> Dim_Date[Date]

There are two solutions in situation: (a) implement role-playing dimensions; or (b) leverage USERELATIONSHIP () at the measure level.

As a Report Developer, I cannot setup option (a). However, using live connection, I can implement option (b) which results in a bloated the model containing many measures.

This Power BI idea proposes the following happy medium: allow Report Developers, using Power BI Desktop, to define which relationships are active or inactive at the visual or report level.

For example, I select my pie chart, click "Define Relationships", in the resulting GUI I then define what relationships to activate or deactivate and then hit apply.

Behind the scenes, this would effectively be the application of USERELATIONSHIP () as a "filter context".