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. Drill to a report page

    Ability to select/click a row on the table or chart and be able to contextually go to another report , with appropriate filters. This is only useful when we are able to hide the pages in the report and they appear only when something is(row or cell) selected on a table or similar chart.

    1,233 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)

      We’ll send you updates on this idea

      66 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →

      Hi everyone. Thanks for supporting this idea – we’re beginning the planning for exactly what this would look like in Power BI. Please keep voting to help us prioritize it, and let us know exactly what your scenarios are in the comments so we can do our best to address them.

      thanks!
      Will

    • Dynamic Parameters for What if analysis

      [Will Thompson] I've just merged a couple of very close scenarios, which all have similar great ideas! Something we're considering for the future, so I'm keen to hear your feedback on this. I like this core scenario of a numeric value that is bound to a slider control, and can then be used as part of some expression.

      - In a sales report, I can adjust a '% increase' slider to see what impact a small change in revenue might have had on my sales.
      - In a mortgage calculator, I can change the % rate, borrowed amount and term to see projected…

      924 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)

        We’ll send you updates on this idea

        61 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
      • Python Connector

        Just like the desktop edition allows you to run an R script to generate data frames that can then be used for data visualization or any other activities within Power BI, let's do the same for Python via the use of python libraries like pandas, numpy, etc.

        122 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)

          We’ll send you updates on this idea

          under review  ·  9 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
        • ISO week number option on Date.WeekOfYear function

          It would be really convenient to align the M function Date.WeekOfYear to the Excel WEEKNUM function to return a ISO 8601 compliant week number. Time intelligence properties are the starting point for a plethora of other calculations. And this "tile" is missing.

          91 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)

            We’ll send you updates on this idea

            5 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
          • Ability to use multiple fields on a legend like an Excel pivot chart

            When I build a pivot table in Excel I can have a legend with multiple metrics. So I can then compare a Scenario, and a price, and a region. I cannot seem to do this in PBI where I can only have 1 field in the legend

            64 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)

              We’ll send you updates on this idea

              11 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
            • Certification Exam for Power BI

              Data Analysts want to be Power BI certified professionals.

              You should have a certification exam for professionals.

              Expected Exam Fee: Below $200

              Any votes?

              63 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)

                We’ll send you updates on this idea

                4 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
              • Allow Data Simulation and Scenario Simulation

                Simulations for BI is a must! Users and analysts must be able to simulate different scenarios and see how data behaves with the change of a number, entry or value.

                53 votes
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  4 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
                • Weighted Average

                  It would be great if there was a way to create a weighted average. For example, if you have units and prices which vary, it would be great to have a quick and easy way to create a weighted average price when you slice the data. It would basically be a sumproduct of the units and prices divided by the sum of the products.

                  51 votes
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    4 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
                  • tree map

                    Need to increase the text size and color of the Details, Value and group in the Tree map. To be precise major and minor label of the tree maps text size.

                    43 votes
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      12 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
                    • Data Analytics Options- Linear Regression,Logistic Regression, Clustering etc.

                      Perform Linear Regression, Logistic Regression ans Clustering Analysis.
                      Can generate Statistical values- pvalues, R2, trend line

                      41 votes
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

                        0 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
                      • Map conditional formatting

                        It would be great, if data on the map could be colored based on conditions. e.g. green if the KPI is achieve and red if the KPI is not achieved...

                        31 votes
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          1 comment  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
                        • Cross Drill / Quick Explore Visuals and Tables

                          The existing drill down functionality that is available in charts / visuals has to be predefined. I would like the ability to allow users to choose their own drill down path using cross drill / quick explore / dice capabilities that we have in other tools such as Excel. If you right click on an item in a table or chart you are provided with a list of the tables to choose from and then you can select attributes within those tables to drill down / across. Restricting users to a predefined or custom drill down is too limiting.

                          The…

                          31 votes
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            1 comment  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
                          • Set Alerts On Bar Graphs and Other Visuals

                            Right now, alerts can only be set against numbers or gauge tiles. It would be nice to set alerts against a measure that is being plotted in a bar graph (and/or other visuals). The user would be notified when one or more of the bars reaches a threshold.

                            29 votes
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

                              2 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
                            • Detect drilldown (drill-down) level to support changing measure / title

                              I have a bar chart with a custom hierarchy that drills through different groups of people (sales managers, territory managers, etc.). On the same report I have a measure that calculates AVERAGE (Sales). I want that measure to show the average sales for the current hierarchy (by Sales Managers or by Territory Managers). Here is some pseudo-code with a new DAX command YAXISVALUES that shows how I would use this:

                              Average Display Value =
                              VAR
                              Total=
                              SWITCH(YAXISVALUES(),
                              "SM", SUM('Sales'[Sales ($)]) / DISTINCTCOUNT('Sales'[SM]),
                              "TM", SUM('Sales'[Sales ($)]) / DISTINCTCOUNT('Sales'[TM])
                              )
                              RETURN
                              IF(ISBLANK(Total),0,Total)

                              See this topic for other use cases: https://community.powerbi.com/t5/Developer/Dyanmically-changing-the-title-based-on-the-drill-down/td-p/33411

                              26 votes
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

                                0 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
                              • Time-Dependent Data Sets - View Data Time dependent (Access to previous versions of the Data)

                                Idea
                                The idea is sort of having a version of loaded data sets on which you can jump back like in a time machine to see how the data was at a certain time.
                                Each load of data is kept as a version with the time stamp of the load.
                                On the Report in PowerBI you can add a slider that lets you select the version you want to see (slide back in time)
                                The Graphs get the possibility to use this Version/Time as Axis etc.

                                What is it good for:
                                Document the data as it has been at a…

                                22 votes
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

                                  0 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
                                • Advanced interactions

                                  Say we have a barchart that display the sales percentages for 10 different products in the current month.

                                  We also have a linechart that displays the total average sales percentage per month, for both the current and last year.

                                  When you allow the barchart to interact with the linecharts, currently both the product AND the month are set as filters on the linechart.

                                  Instead, I would like to select which interactions apply. In this example, only the product should filter. That way when you select a product in the barchart, the linecharts display the sales history of that product (rather…

                                  22 votes
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

                                    1 comment  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Semantic Layer! Major features missing: dynamic parameters, enforced parameters upon field selection, dynamic SQL generation (using params)

                                    All in the title. A semantic layer such as SAP Business Objects universes is the BASIS for self-service BI. Exists for over 30 years now, and MS does not even have dynamically populated prompts. Frustrating.

                                    19 votes
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

                                      1 comment  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
                                    • conditional formatting intervals

                                      It would be very useful to be able to tailor conditional formatting by applying users own definitions for intervals.

                                      Example being:
                                      1-3,Red
                                      4-6,Yellow
                                      7-9,Green
                                      or
                                      1-25%, #5956C3
                                      26-50%, #C356C1
                                      51-75%, #5C9B9C
                                      76-100%, #73C374

                                      18 votes
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)

                                        We’ll send you updates on this idea

                                        1 comment  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Introduce a powerful export function

                                        Right now, Power BI can only export data from the report view to CSV. I would like to be able to export from the "Edit Queries" view to different formats, like CSV, Excel, Access DB, XML, Sharepoint, HTML, etc.

                                        18 votes
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

                                          0 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Custom markers on X or Y axes of charts

                                          I primarily deal with time-series data, which usually involes line charts, vertical bar charts, or combination charts. Often when dealing with time series data you want to be able to track the occurrence of specific events to designate that something of interest occurred at a particular time to inform later analysis.

                                          I would like to be able to define custom markers on the Y axis (time) in order to indicate that particular events occurred on those dates. Being able to do so would help make later analysis easier.

                                          At a minmum I'd like to be able to put vertical lines…

                                          18 votes
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)

                                            We’ll send you updates on this idea

                                            0 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 14 15
                                          • Don't see your idea?

                                          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.