Power BI Ideas

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

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

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

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

  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

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

    We’ll send you updates on this idea

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

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

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    31 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,514 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    1,200 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 →
  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,160 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    71 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,059 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    1,029 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. Dark Mode for Power BI

    Having a dark mode especially on the creator UI when putting things together would be helpful, similar to other MSFT apps (Azure, Office 2016, etc).

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

    We’ll send you updates on this idea

    188 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?

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

    We’ll send you updates on this idea

    125 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  18. Measure Dependency View (similar to the Query Dependency View)

    The newly introduced Query Dependency view is phenomenal but what we really need is a Measure Dependency view. Here is what it might look like: http://ppvt.pro/2eXKndh
    And a video detailing this idea: https://youtu.be/sYjBB_Ef66M

    In one of my production models I have 60 Queries, but I have 200+ measures! I believe that is typical; usually I build Queries and Measures as lego blocks, combining simpler ones into more complex ones needed in the end. In fact I needed it so badle that I attempted to build a Measure Dependency view using NodeXL. While that works, it's a lot of heavy lifting.…

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

    We’ll send you updates on this idea

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

    696 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 →
  20. 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.

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

    We’ll send you updates on this idea

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