I have a number of charts within a single dashboard in Power BI, as well as a number of measures that I want to examine individually within this dashboard - hopefully by cycling through them.

Instead of creating separate pages/dashes for each measure, I would like to dynamically populate each chart with a chosen measure most likely accessed via a filter.

I know something like this can be done in Tableau, (http://breaking-bi.blogspot.com/2013/02/dynamically-choose-fields-displayed-on.html), but can this replicated in Power BI?

1 Answer 1


I would use the disconnected Measure table and a SWITCH ( TRUE ... ) function.

There's a good explanation of this technique on this post:


In Power BI you can use Enter Data to create your Measure table.

  • 2
    Thanks so much for the tip on using StackOverflow for Power BI questions and on the link. It worked a treat! Will leave my question and your answer up on SuperUser unless you suggest otherwise (delete here and repost on StackOverflow)
    – Chris
    Mar 20, 2016 at 1:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.