When you have a range of core measures, it can be challenging (and time-consuming) to create multiple copies of all content with all the different measures, so is there a better way? What-if there was a way to let your customers choose what they wanted to look at on a report and have that simple and readily available so people could see how the different measures reflect across the visuals? Lastly, of course, what-if you could what-if.
Disconnected Tables are a great way of dynamically selecting a measure or value to present on your reports. In our example with the NYC Taxis, we used a disconnected table to help a customer make the most of the report without creating pages for every measure.
Disconnected =
VAR Selected = SELECTEDVALUE(Disconnected_Show[Order],0)
RETURN
SWITCH( TRUE(),
Selected = 0, [Journeys],
Selected = 1, [Total Fares],
Selected = 2, [Total Passengers],
Selected = 3, [Total Tips],
Selected = 4, [Average Distance],
Selected = 5, [AVG Passengers],
Selected = 6, [Tip%]*100, blank()
)
As a bonus, we also used the dynamic titling within Power BI to cope with the challenge you face with Disconnected Tables… simply as a single DAX statement is used, you can apply only a single Number Format.
SelectedToShow = SELECTEDVALUE(Disconnected_Show[Heading], BLANK ( ) )
Remember that you may also see Disconnected Tables referred to as Disconnected Slicers and Disconnected Measures.