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. Slicer Hierarchy

    Dragging a hierarchy into a report and change it to slicer... can we get a slicer with hierarchy (collapsible/expandable)?

    1,472 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    73 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  2. create multiple apps from same workspace

    create multiple apps from same workspace infect from same Dataset without replicating the dataset multiple times.
    only option we have now is to update the app and only one app per workspace can be created which a kind of restrict the workspace usability.
    If we can create multiple apps share it with different users without creating multiple workspace ... means same dataset no dataset replication, will save the storage as well.

    1,470 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    146 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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.

    1,437 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    26 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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,388 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    1,383 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    80 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!

  6. DAX Query Language Visual

    I see big value in creating a visual that can display the results of a DAX query. One way this could be deployed is a follows.
    * Add the new visual to the report canvas
    * Write a DAX query that returns a table (of course) and add this to the visual
    * The visual would respect any cross filtering coming from the report just like any other visual.

    This would give report writers very granular control to display records without having to use a table visual and a measure that triggers the display of the correct records.

    1,315 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    At the moment we don’t have any plans to implement this. It sounds like it’s mostly useful for learning/training? If there are other ‘production’ scenarios that you think it’d be useful, where a regular table/matrix wouldn’t work, please let us know in the comments!

  7. Custom order for legend

    I should be able to order the "legend" and the values for each legend category in a stacked bar chart. This is similar to "series order" feature in Excel

    1,312 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    139 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  8. Load data from Office 365 Planner to PowerBI

    Create an a connection withrowgh Office 365 Planner and Power Bi.

    1,297 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    151 comments  ·  Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
  9. Copy/paste the data behind the visual in Power BI to other applications

    I can copy the visual either as image or data table and paste it in other applications.

    1,258 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    117 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  10. Clustered+stacked Chart

    A column/bar chart with both clustered and stacked features (stacked clustered bar/column chart).

    http://www.originlab.com/doc/en/Tutorial/images/Clustered-Stacked_Column_Chart/Clustered-Stacked_Column_Chart.png

    1,245 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  135 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  11. Totals in stacked column charts

    During several presentations I get questions regarding the total of stacked columns. In the current situation you can select to label all the parts of the stacked column but no grand total. I would like to see the option to add a label to the Visuals which shows the total of the stacked column (this counts for values only). Ideally this total would deviate together with the drilldowns you select, so it stays interactive whatever filters you select or subsets you create on your dashboard.

    1,235 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  25 comments  ·  Custom Visuals  ·  Flag idea as inappropriate…  ·  Admin →
  12. Hyperlink in Visuals

    You should be able to insert a hyperlink field into a visual so when a user selects on the visual, it can take them to the desired page.

    1,223 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    21 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  13. Auto/Scheduled export of data

    In some of our dashboards we have claims data that we show from month to month. Due to the mass amount of data we get on a monthly basis we only archive 60 days worth of this data. instead of having a user export manually every month, it would be a real helpful to have the option to schedule an export of data for time/date, one time/reoccurring, monthly/weekly/daily and to be able to input the format type (pdf, excel, etc.).

    1,131 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    121 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  14. Increase Export Data Limits

    In late 2016, Power BI improved our export data options to allow exporting up to 150,000 rows to Excel from a visual on a Power BI dashboard for Pro users. If you require higher limits, please vote on this idea. If you have more specific requirements, please leave them in the comments.

    1,058 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    125 comments  ·  Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
  15. SAP BusinessObjects BI Universe

    All of the current Ideas that mention SAP BusinessObjects BI Universe integration are marked as completed as this feature was offered pre June/July release. This is nearly a critical requirement for adoption in my organization.

    I had previously heard that this was removed due to licencing restrictions, can we get an official response on that? Is there any possibility of this being re-integrated?

    1,054 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    131 comments  ·  Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
  16. Clear all slicers

    Clear ALL slicers on a page with one click, perhaps an addition to a slicer for a clear all slicers button or perhaps a custom visualization that is a button to press to clear all slicers.

    1,048 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    49 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  17. Show column data profile statistics in header

    Add a column data profile histogram in the data view for every column in Power BI Desktop. This handy feature exists in Power Query (sometimes only on sampled data).

    Add this feature to Power BI Desktop as well, please.

    1,038 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    1,029 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    56 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  19. Security - Ability to maintain source security for reports published on BI Sites

    The general requirement is that visualizations (Power View, SSRS etc...) must not circumvent existing policies, or introduce yet another set of security policies on top of those already implemented at the source.

    * For example, a visualization of sales data needs to reflect the policy that account managers can only read sales data for their region.
    * For performance reasons, this is enforced at the source by injecting predicates into the query based on the end users identity. If identities for end users are not passed down the process chain into the data layer, it leaves us little option but…

    991 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    88 comments  ·  Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
    under review  ·  Sirui Sun responded

    Hey all!

    We’ve continued to make progress here, so I wanted to update this thread with our current capabilities for maintaining security on dashboards/reports.

    As always, all of this information can be found in our Row-Level Security (RLS)documentation: https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-rls/

    > If you have set up RLS in Analysis Services, Power BI will send the signed-in user’s credentials to Analysis Services, and respect the RLS rules set up on the on-premises model.

    > Separately, you can set up RLS in Power BI for data sources that you import or connect to via DirectQuery. This process starts in PBI Desktop, where you define roles, and write DAX to constrain what data these roles can see. As part of this process, can you use the UserPrincipalName() DAX function to get the current signed in user’s UPN (e.g. joe@contoso.com). Then, once you publish to service, you can assign users to these…

  20. Drill Mode By Default

    It should be good if we can set Drill Mode ON/OFF by DEFAULT instead of clicking manually on the arrow every time on report.

    989 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    200 comments  ·  Reports  ·  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.