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. Dynamic Date Slicer (improve relative date slicer)

    This is a repost of my idea that was closed as completed, but the 'relative date slicer doesn't allow any of the described request hence my idea is not implemented....

    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.

    471 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

      28 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →

      The relative date slicer (a Preview feature as of June ‘17) gets us close to this with the ’This Month’ or ‘This Year’ settings. That is a dynamic date selection that updates based on the current system date. We plan to add a ‘YTD’/‘MTD’ option to specifically select a range from the start of the month/year up to today, hopefully that’ll address the remaining requirements!

    • Create calculated columns when using SSAS live connect

      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 columns in this mode as well!

      432 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

        13 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
      • Please Bring back "Test as role" in Power BI Service

        It is imperative that the ability to "Test as role" be restored within the Power BI web service.

        Previously, there was a blue bar that popped up on the top of the Power BI web service that allowed you to view a dashboard or report as a different user. This could be accessed by going to Datasets > Security > Row Level Security > Test as role. This was extremely important for testing RLS security role membership and to ensure that the roles themselves were operating as expected.

        Many organizations need this functionality for training, demos, and testing. Please return…

        60 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

          6 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
        • clustering arcgis

          I need to make ArcGIS maps Clustering theme to count the number of subscribers in each geographical area by geo coordinates inside it's bubbles.

          For example,
          I have table with this kind of data:

          LATITUDE LONGITUDE Subscribers count
          43.25667 76.92861 100
          43.25668 76.92868 200

          As I can see, ArcGIS clustering theme counts only quantity of geo coordinates from the source table inside the bubbles, but does not count quantity of subscribers in each bubble. I would like there be possibility to make ArcGIS to count quantity of subscribers in each bubble and make quantity to be summarized in bubbles when…

          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

            16 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
          • restrict export to excel

            We see that there is a way at the tenant level to restrict the export to excel as well as the analyze in excel but we need an option per dataset (preferred) or per Power BI Report to restrict this option. The problems we are facing is for both sensitive information and also for volumes of data that is too large for this option. We need to have the ability to stop this option for these specific datasets but allow it for other non-sensitive information - so the tenant level option is not appropriate.

            68 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

              6 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
            • Subscribe *others* to emails of reports

              Extend the email subscription feature, currently in public preview, to enable subscribing *others* to email snapshots of reports.

              More information about the existing email subscriptions feature can be found here: https://powerbi.microsoft.com/en-us/blog/introducing-email-subscriptions-in-power-bi-stay-informed-when-it-matters/preview/

              745 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

                33 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
              • Allow default filtering based on current user

                It would be nice, even if not essential, to allow a report to slice by default to the current user's data. For instance, I might envision:

                - A dimUser table that can slice by default to the USERNAME() output
                - A dimGeo table that can slice by default to the city/state/country of the session's IP address
                - ...and so forth

                35 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  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
                • Drill through that considers slicer/filter context of a parent visual

                  The current drill through capability does not appear to consider an active filter/slicer value for a visual unless the dimension being filtered is included in the parent visual. I think it would be helpful if it did.

                  For example; a table of customers subject to a slicer for specific stores should pass on both the customer and store values if these dimensions are both listed as drill through filters.

                  12 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  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
                  • Print (or) Save as Pdf option for each individual report and Save whole report as PDF

                    We can save the whole report as Pdf for the data displayed in tables with conditional formatting.

                    137 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  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
                    • Allow formatting datetimezone fields to user local timezone

                      Typically date & time information is available in UTC (if not then put it to UTC at source), you just want it rendered in the users' locale/time zone at reporting time.

                      Adding an option to format datetimezone fields in the users' locale/time zone (based on the user account settings) would probably solve 90+% of requirements for rendering time zone information.

                      Currently MS does not provide for showing offset information (or local time zone) as you only have date/time format options, but in the query editor you can set type to datetimezone which show offset info so it's clearly available -…

                      12 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  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
                      • Export to PowerPoint with filters applied

                        PowerPoint Export to take into account filters that have been applied to the report prior to export. This is essential for users which need to filter on historic dates and then wish to export the report with those details.

                        516 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

                          33 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →

                          Hey all – we’re looking into how best to tackle this and other filter/slicer-related functionality. We’ve put together a short survey to better understand different use cases and what improvements would make the experience better.  If you have a few moments, the survey takes about 10 minutes to complete.  We appreciate your feedback!
                          https://aka.ms/x998cx

                        • Apply formatting to a data visualisation before data is added to it

                          It would be useful, particularly in the creation of Report Templates, if formatting options could be applied to a data visualisation before data is applied to the data visualisation. Currently all formatting options are greyed out until data is applied.

                          9 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  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
                          • Import report template into existing report

                            Currently we can import a Report Template into Power BI Desktop and create a new report using it. However, it would be useful to have the option of importing a Report Template into an existing report. The option to select which Report Pages to import from the Report Template would be even more powerful and advantageous.

                            8 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  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
                            • Include report filters in Drillthrough action

                              As much as I like the new Drillthrough actions, it seems a bit lacking in that it does not also pass through any report filters that are active on the source report on the source report.

                              9 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  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
                              • Allow customization of email subscription schedule

                                Extend the existing email subscription feature to allow me to specify exactly *when* the email is sent out - e.g. send me the email at 2pm every Monday.

                                More information about the existing feature can be found here: https://powerbi.microsoft.com/en-us/blog/introducing-email-subscriptions-in-power-bi-stay-informed-when-it-matters/

                                412 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

                                  14 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
                                • clean drillthrough filter on back button

                                  I was very excited about the new drillthrough option in the September release and have implemented in my solution.
                                  However I would like the option of having the BACK button clear the drillthrough filters.
                                  I am using general report pages as drillthrough destinations and it can confuse the user if there are filters done "behind the scenes"

                                  6 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  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Remember Filters I set on Reports!

                                    We have a number of different business parts and all our reports are built generically so that you can change the area you are interested in by filter.

                                    Each person is generally only interested in one specific part. However every time each user returns to the report they have to re set the filter they are interested in.

                                    The only way we can give users a friction-less experience is to duplicate reports where the only difference is the default filter, which is obviously ridiculous.

                                    So please add a feature to remember the last filter that was set by each user…

                                    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

                                      2 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Subscribe to email snapshots of reports in *specific filter/slicer states*

                                      Extend the email subscriptions feature, currently in public preview, to include support for email snapshots of reports in specific filter/slicer states.

                                      More information about the feature can be found here: https://powerbi.microsoft.com/en-us/blog/introducing-email-subscriptions-in-power-bi-stay-informed-when-it-matters/

                                      272 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

                                        6 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →

                                        Hey all – we’re looking into how best to tackle this and other filter/slicer-related functionality.

                                        We’ve put together a short survey to better understand different use cases and what improvements would make the experience better.  If you have a few moments, the survey takes about 10 minutes to complete.  We appreciate your feedback!

                                        https://aka.ms/x998cx

                                      • Expanded formatting options in text boxes

                                        The text box included in Power BI has very limited formatting options. The following items would make the text box more useful:

                                        -Bullet/Numbering
                                        -Spell Check
                                        -Strikethrough
                                        -Subscript
                                        -Superscript
                                        -More Fonts

                                        The text box also tends to revert back to the default font randomly and the highlighting behavior is awkward. While the text box is not an advanced feature it should have basic functionality and should be useful.

                                        6 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  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Extend DAX Format Function - Simple, but HUGE Benefits

                                          Extend Format Function to allow color in format code like in Excel. This would allow far more expressive conditional formatting in formulas. Take it a step further and add codes for bolding, italics and other formatting types. This would allow full flexibility in formatting of reports such as bolding certain rows, etc. Simple change - HUGE benefits! The finance community will thank you greatly!

                                          EXAMPLE:

                                          =FORMAT(1, "[[RED]] #") //formats number as red
                                          =FORMAT(1, "[[#ff0000]] #") //formats number as red (using hex code)
                                          =FORMAT(1, "[[RED;BOLD]] #") //formats number as red and bolds

                                          4 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  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 84 85
                                          • 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.