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. When will the KPI Red/Yellow/Green Indicators be available on PowerBI Desktop?

    KPI Red/Yellow/Green Indicators were available in Power Pivot. With the new Power BI Desktop this feature is not available anymore. If you import from PP to the Desktop it converts the RYG Indicator Dots to a number. Will the Red/Yellow/Green Indicators be added back to PowerBI Desktop? If so When?

    4,413 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

      223 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,280 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

        73 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
      • Python Script in Power BI

        It's great that Power BI already has the capability to run R scripts for data transformation. It would be even better if we could run Python script.

        2,275 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

          170 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,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  ·  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…

          • Power BI Designer API

            Power BI Designer saves a local PBIX file, which can be a file to export data and data model – in other words, it’s a format that contains a complete semantic model. All the applications that today export data in several formats (CSV, Excel, XML), might provide a richer semantic model exporting a PBIX file.

            Many ISV/SI that have OLTP and other applications that stores data in some database, usually struggle to offer a compelling BI story to their customers. The smaller they are, the more they feel this pressure because probably the effort they can put in their custom…

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

              65 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
            • Calculated measures when live connected to MDX cubes

              In May 2017 Power BI Desktop started supporting creation of DAX measures when working in live connect mode to an external SSAS model: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-feature-summary/

              Vote on this idea if you want support for calculated measures against multidimensional models too.

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

                121 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
              • Conditional Formatting for Text

                It would be great to conditional format a table and/or a matrix based on the cell text, not only numbers

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

                  56 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
                • Add a multiple columns sort featue

                  If it is possible please provide the multiple columns sort . For example I want to sort the table visualization based on Priority and severity

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

                    121 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
                  • Page (Tab) level Security.

                    Add security to show/hide any specific page (Tab) on a report based on users privileges / Roles.

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

                      157 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
                    • Add expand/collapse feature to column headers

                      Vote on this idea if you want expand/collapse on column headers in the matrix similar to what was shipped for row headers in November (https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2018-feature-summary/#expandCollapse).

                      869 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

                        36 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
                      • 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.

                        700 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

                          41 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
                        • No alignment options available in card visual.

                          Alignment option like (Center, Left or Right) is not available for data in card visual.

                          668 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 →
                          • Measure Dependency View (similar to the Query Dependency View)

                            The newly introduced Query Dependency view is phenomenal but what we really need is a Measure Dependency view. Here is what it might look like: http://ppvt.pro/2eXKndh
                            And a video detailing this idea: https://youtu.be/sYjBB_Ef66M

                            In one of my production models I have 60 Queries, but I have 200+ measures! I believe that is typical; usually I build Queries and Measures as lego blocks, combining simpler ones into more complex ones needed in the end. In fact I needed it so badle that I attempted to build a Measure Dependency view using NodeXL. While that works, it's a lot of heavy lifting.…

                            647 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

                              34 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
                            • field of "duration" type

                              is it possible to add support for "duration" data type in the report view as in Power Query?

                              630 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

                                105 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
                              • Organizing Measures into Categories using Folders

                                Adding few measures to your data model in PowerBI could be easily managed, but what about adding tens or even hundreds of measures! Organizing those measure into categories using folders could help a lot.

                                To show you what I exactly mean, I will demonstrate the alternative way to create those folders using empty tables:

                                1. Select "Enter Data" from the Home ribbon > Change the column name to "Id" and choose the table name e.g. "_Financial Measures" (Create all the tables)
                                2. Select "New Measure" from the Modeling ribbon (Or choose any shortcut) > Type and create a new measure…

                                622 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

                                  10 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
                                • Dynamically specify Data Colour using column e.g #A66999.

                                  The ability to provide specify the Data Colour for each item in the Legend field. E.g. a column from the data source in which to specify the colour e.g. #A66999 for each item in the Legend field.

                                  This would apply to all the standard charts, e.g. bar, column, line chart, any of the charts with the Legend property.

                                  603 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

                                    planned  ·  25 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
                                  • When showing subtotals at the bottom, show the attributes there as well and not on top

                                    When I choose the option to show the subtotals at the bottom, I expect to see the attribute name there as well and not just on top. This is especially crucial for financial statements, like shown here: https://wp.me/p6lgsG-YC

                                    An option to toggle between showing attributes at the bottom only or at the top as well would be ideal.

                                    561 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

                                      16 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Power BI collaborative development

                                      allows multiple developers to work collaboratively on the same PBIX.

                                      Idea could be separate back-end (advanced editor) and fron-end (modelling and report design) or allows the possibility to merge more than one pbix.

                                      546 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

                                        8 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Power Map integration

                                        Power BI designer should integrate Power Map design experience, don't let Power Map just like a stand-along part of Power BI...

                                        544 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

                                          30 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
                                          under review  ·  Filip Karadzic responded

                                          We are looking to improve our maps. A new Shape Map control is expected in the summer which will solve some of these issues.

                                        • Conditional Formatting throughout

                                          It would be great if you could do conditional formatting throughout all of Power BI Desktop. e.g. text boxes have conditional formatting based on your data. It would be great if conditional formatting also worked with the different bars in bar charts etc.

                                          541 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

                                            39 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 133 134
                                          • 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.