jmoffett

My feedback

  1. 1,770 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

      54 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →

      From the comments and scenarios everyone’s describing, the problem is really that you need a way to allow end-users to change which measure is displayed in a visual on the fly.

      As a few folks have mentioned, the FORMAT function might help in the interim, as long as you’re showing the results in text rather than a chart. https://docs.microsoft.com/en-us/dax/format-function-dax has details on how to use that.

      The expression-based formatting feature that we’ve started work on may help to a certain extent, but that’s really designed to change a visual’s properties rather than the data type or format. We’ll look into extending that work to support this scenario as well.

      We’re moving this to Backlog status – our core plan is to build ways that end-users can change the dimensions or measures that are visible in a chart on the fly. They’ll be able to explore much more freely rather than…

      jmoffett commented  · 

      Need to add this! This is a key feature for any business intelligence tool.

    Feedback and Knowledge Base

    Ready to get started?

    Try new features of Power BI today by signing up and learn more about our powerful suite of apps.