Power BI Ideas

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. 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).

    4,298 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  78 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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

    4,227 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

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

    3,715 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    3,695 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    3,464 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    60 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…

  6. Option to use either light or dark interface.

    New Desktop app update installed an almost white user interface. There is zero contrast which is not good for the eyes. I see where some people have requested a light interface so incorporate an option to select either light or dark theme like in the Office apps.

    3,423 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    491 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  7. Support creating calculation groups in Power BI Desktop

    Support the creation of DAX calculation groups in Power BI Desktop - otherwise Power BI can only consume calculation groups created in Analysis Services, whereas it would be very useful to have this feature in any Power BI model.
    Even just a simple text window with a script would be fine. You can clean up the UI later.
    Thanks.

    2,339 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    2,273 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    80 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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,953 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    10 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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,820 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    101 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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,715 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    41 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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,486 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    142 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  13. 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,337 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

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

    1,292 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    154 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  15. 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 e.g. Total…
    1,115 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    11 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  16. Built in Git support in PowerBI Desktop

    When you create a PowerBI report in Power BI Desktop it transparently create \ use a git repository. So you just worked normally, then when you hit publish, it actually push to remote.

    Gitignore could be used to exclude data from being published to the repository. PowerBI would have version control which is desperately needed.

    This would work well with the whole Microsoft buying Github \ Azure DevOps, both from the perspective of promoting good practices such as code version control and CI\CD - process of developing in development and promoting to UAT\production

    It would also allow IT to get…

    1,041 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    12 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  17. field of "duration" type

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

    869 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    140 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  18. Relative Date filter week Mon-Sun

    the Relative Date filter options for the calendar week goes from sunday through saterday.

    Most companies I know, go from Monday through Sunday. Please give us the option to choose in the filter, or set it though the localization.

    773 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    115 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  19. VBA for Power BI Desktop

    Ability to provide a custom UI for a user to enter some parameters / inputs prior to refreshing the data model and publishing to Power BI

    750 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    722 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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