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. When will the KPI Red/Yellow/Green Indicators be available on PowerBI Desktop?

    KPI Red/Yellow/Green Indicators were available in Power Pivot. With the new Power BI Desktop this feature is not available anymore. If you import from PP to the Desktop it converts the RYG Indicator Dots to a number. Will the Red/Yellow/Green Indicators be added back to PowerBI Desktop? If so When?

    4,910 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    232 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →

    Hi everyone! To give you an update here, we’ve begun work on this feature!

    The first step will be bringing icon sets as a conditional formatting option. You’ll be able to set rules and icons, very similar to what you can do in Excel today. We want to get this out to you quickly, so it’ll be available in table and matrix visuals only to begin with.

    Based on the comments on this thread, we’re focusing on the indicators first and looking for feedback on how soon after we need to follow with model-based KPIs. Please keep letting us know in the comments if you need model support for this too!

    Thanks for your patience and for engaging and voting!

  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

    3,585 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    80 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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,089 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    1,838 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

  5. 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).

    1,612 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  43 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  6. 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,399 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    72 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  7. 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,342 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

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

    1,281 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    1,219 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    135 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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,036 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    885 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

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

    812 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    789 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

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

    685 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    664 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    641 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    9 comments  ·  Desktop  ·  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.

    627 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  18. Dynamically specify Data Colour using column e.g #A66999.

    The ability to provide specify the Data Colour for each item in the Legend field. E.g. a column from the data source in which to specify the colour e.g. #A66999 for each item in the Legend field.

    This would apply to all the standard charts, e.g. bar, column, line chart, any of the charts with the Legend property.

    623 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    planned  ·  25 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  19. Conditional Formatting throughout

    It would be great if you could do conditional formatting throughout all of Power BI Desktop. e.g. text boxes have conditional formatting based on your data. It would be great if conditional formatting also worked with the different bars in bar charts etc.

    577 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    40 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  20. Data Catalog integration in PowerBI Designer

    The PowerBI Designer is missing integration with the Data Catalog and there is no online search functionality. The data catalog is a core component of the reporting solution so let me use it with the Power BI Designer

    554 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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