Power BI Ideas

How can we improve Power BI?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Composite models when connected to SQL Server Analysis Services Tabular (SSAS)

    We really love the new feature of 'Composite Models' in the Power BI July 2018 update! This enables us to join custom lists with DirectQuery sources.

    It would also be beneficial if this would also work when connected to SSAS Tabular in DirectQuery.
    This would stronlgy improve the enterprise features of Power BI.

    792 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

      48 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
    • Measure Management & DAX Editor

      Anyone who uses PowerBI long enough has had a PBIX with 50-60 measures and it has become time consuming and tedious to mantain. In Excel you can do a quick find/replace to edit several formulas - in PowerBI you need to select each one individually. An "excel-like" interface for editing measures would save a lot of time! This would take PowerBI to the next level regarding productivity. I've prepared a mockup for this as well as a DAX Editor. Let me know what you think.

      Mockup: https://i.imgur.com/z6TBOQb.png?1

      3,412 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

        75 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
      • Conditional formatted measures using SWITCH

        A current limitation in Power BI SWITCH measures (and all Power Pivot actually) is that a SWITCH measure must have a single format. It is currently not possible to conditionally format the measure result based on any criteria - it is one single format only. There are valid use cases where you may want to change the format of the SWITCH measure depending on the result. Consider the following SWITCH statement
        myMeasure = SUMX(MeasureTable,switch([selected measure],
        1,[Total Sales],
        2,[Total Cost],
        3,[Total Margin],
        4,[Chg Sales vs LY %]
        ))
        The first 3 results are all currency format, but the last result is…

        1,805 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

          55 comments  ·  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…

        • Data Catalog integration in PowerBI Designer

          The PowerBI Designer is missing integration with the Data Catalog and there is no online search functionality. The data catalog is a core component of the reporting solution so let me use it with the Power BI Designer

          548 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

            43 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
          • Don't see your idea?

          Power BI Ideas

          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.