Power BI Ideas

How can we improve Power BI?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(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.

    2,297 votes
    Vote
    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)
      You have left! (?) (thinking…)
      54 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 date slicer

      The new date slicer is awesome, but it would be so nice if you could set a dynamic date selection instead of a static. With a static filter the user will always have to set the dates before the saved report makes sense - especially as the report gets older.

      Dynamic options could be
      YTD, QTD, MTD, WTD, Today, This Year, This Quarter, This Month, This Week and so on.

      1,469 votes
      Vote
      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)
        You have left! (?) (thinking…)
        30 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
      • 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…

        1,040 votes
        Vote
        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)
          You have left! (?) (thinking…)
          under review  ·  24 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
        • Time intelligence base to improve value of YTD, MTD.....

          Time intelligence is used frequently when creating reports and it’s a really strong feature, but it could be made even stronger if you had the option to change the base date for this.

          Let’s imagine we have a report showing some year to date and last year to date values, if I open this report it will always show the values based on the current date, but very often around month, quarter or year change you would really like to view this result not including the values of e.g. the current month.

          Let’s imagine that today’s date is May 11th…

          560 votes
          Vote
          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)
            You have left! (?) (thinking…)
            6 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.

            194 votes
            Vote
            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)
              You have left! (?) (thinking…)
              under review  ·  4 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.

              177 votes
              Vote
              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)
                You have left! (?) (thinking…)
                4 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?

                86 votes
                Vote
                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)
                  You have left! (?) (thinking…)
                  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.

                  75 votes
                  Vote
                  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)
                    You have left! (?) (thinking…)
                    3 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.

                    73 votes
                    Vote
                    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)
                      You have left! (?) (thinking…)
                      1 comment  ·  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
                      Vote
                      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)
                        You have left! (?) (thinking…)
                        6 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

                        62 votes
                        Vote
                        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)
                          You have left! (?) (thinking…)
                          0 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.

                          60 votes
                          Vote
                          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)
                            You have left! (?) (thinking…)
                            2 comments  ·  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.

                            58 votes
                            Vote
                            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)
                              You have left! (?) (thinking…)
                              2 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...

                              44 votes
                              Vote
                              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)
                                You have left! (?) (thinking…)
                                1 comment  ·  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…

                                43 votes
                                Vote
                                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)
                                  You have left! (?) (thinking…)
                                  0 comments  ·  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.

                                  39 votes
                                  Vote
                                  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)
                                    You have left! (?) (thinking…)
                                    1 comment  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Enable ArcGIS Maps for PowerBI to create routes from a list of ordered points

                                    Enable the creation of routes from lists of ordered points (or latitude and longitude coordinates), so to be able to track GPS tracks.

                                    33 votes
                                    Vote
                                    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)
                                      You have left! (?) (thinking…)
                                      0 comments  ·  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…

                                      33 votes
                                      Vote
                                      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)
                                        You have left! (?) (thinking…)
                                        1 comment  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Enable ArcGIS Maps for PowerBI to use custom Basemaps

                                        Add the ability to directly upload custom basemaps, so to be able to use nautical or relief charts (for example).

                                        32 votes
                                        Vote
                                        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)
                                          You have left! (?) (thinking…)
                                          0 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

                                          29 votes
                                          Vote
                                          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)
                                            You have left! (?) (thinking…)
                                            0 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 9 10
                                          • 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.