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. 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,205 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 →
  2. Ability to use multiple fields on a legend like an Excel pivot chart

    When I build a pivot table in Excel I can have a legend with multiple metrics. So I can then compare a Scenario, and a price, and a region. I cannot seem to do this in PBI where I can only have 1 field in the legend

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

    We’ll send you updates on this idea

    42 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  3. Enable What If Parameters with Analysis Services

    It would be nice to do what if analysis on Analysis Services tabular models in PowerBI.

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

    We’ll send you updates on this idea

    23 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  4. ISO week number option on Date.WeekOfYear function

    It would be really convenient to align the M function Date.WeekOfYear to the Excel WEEKNUM function to return a ISO 8601 compliant week number. Time intelligence properties are the starting point for a plethora of other calculations. And this "tile" is missing.

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

    We’ll send you updates on this idea

    14 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  5. Power BI Service recognize local time zone for TODAY() and NOW() time intelligence functions

    As of now, the reports that I create on desktop utilize a lot of time intelligence functions and relative date filters. This is completely fine so long as I view the report on the desktop. Once I publish the report up to the service and then utilize those visuals in dashboards I run into this issue. All of my time intelligence functions (TODAY & NOW) and relative date filters convert to UTC.

    This issue causes my data to roll over to the next day 5 hours early which affects all of my subscriptions.

    It would be absolutely fantastic if Power…

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

    We’ll send you updates on this idea

    23 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  6. Maintain dashboard/report usage metrics data for >90 days

    The currently released usage metrics feature only keeps data for 90 days. Please increase the data retention period.

    FYI: the documentation for the usage metrics feature can be found here: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-usage-metrics/

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

    We’ll send you updates on this idea

    16 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  7. Add option to set a single date via date slicer

    The new date slicer is brilliant, but it would be nice if you were able to just select a single date (equal option).

    This will make it more simple for users to use with balance (periods to date) measures and other measures that use time intelligence.

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

    We’ll send you updates on this idea

    13 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  8. Custom (Reusable) DAX Function

    I'd like to be able to create reusable functions in DAX, instead of using the same DAX code in multiple measures.

    Example: I have some complicated DAX code, which calculates the no of working seconds between two date-times. This excludes holidays, weekends, and only counts seconds from the start of the work-day, to the end of the work-day.

    I use this DAX code a lot, for many measures which need to be in "Working Time" (working hours/minutes).

    I would love to not have to copy-paste a bunch of code into all of my measures, but to be able to create…

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

    We’ll send you updates on this idea

    13 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  9. Ability to use Trend Line with Categorical Values in X-axis

    Right now we can only use trend lines for continuous values in the x axis. It would be great if a categorical value could also be used, such as month name.

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

    We’ll send you updates on this idea

    27 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  10. Usage metrics for Power BI apps

    Augment the existing usage metrics feature to make it easier to see usage metrics for a Power BI app - e.g. total views/viewers for the App.

    Notice that this is _already possible_ with the existing usage metrics, via customization of the pre-built report. More details in the documentation here:
    https://powerbi.microsoft.com/en-us/documentation/powerbi-service-usage-metrics/

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

    We’ll send you updates on this idea

    19 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  11. Compare two Queries - Columns

    I would like to have the ability to do a "compare tables" or "compare queries" option.

    I understand that there are visuals/queries I can build to compare the DATA within two separate queries but I want to compare the two queries. I want to know how many columns are in TableA versus how many are in TableB and which column names are different from each other. When I have two tables with 150 columns (give or take) and they are allegedly a copy of each other I want to be able to confirm that all 150 in columns in TableA…

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

    We’ll send you updates on this idea

    1 comment  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  12. Certification Exam for Power BI

    Data Analysts want to be Power BI certified professionals.

    You should have a certification exam for professionals.

    Expected Exam Fee: Below $200

    Any votes?

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

    We’ll send you updates on this idea

    9 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  13. Allow Data Simulation and Scenario Simulation

    Simulations for BI is a must! Users and analysts must be able to simulate different scenarios and see how data behaves with the change of a number, entry or value.

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

    We’ll send you updates on this idea

    4 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  14. Set Alerts On Bar Graphs and Other Visuals

    Right now, alerts can only be set against numbers or gauge tiles. It would be nice to set alerts against a measure that is being plotted in a bar graph (and/or other visuals). The user would be notified when one or more of the bars reaches a threshold.

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

    We’ll send you updates on this idea

    6 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  15. color scale legend

    for scatter plots, conditional formatting, and line plots, enable data viz to have a legend that is a color scale gradient

    for example,
    1) in scatter plot using saturation, we should have a legend that indicates what the darker and lighter colors represent
    2) same goes for conditional formatting in tables and matrices
    3) line charts without a field in the "legend" bucket (i.e. line charts represented by a single line) should be eligible for a line graph that has its color change according to a gradient as the value increases or decreases (e.g. a line graph that plots a…

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

    We’ll send you updates on this idea

    8 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  16. Detect drilldown (drill-down) level to support changing measure / title

    I have a bar chart with a custom hierarchy that drills through different groups of people (sales managers, territory managers, etc.). On the same report I have a measure that calculates AVERAGE (Sales). I want that measure to show the average sales for the current hierarchy (by Sales Managers or by Territory Managers). Here is some pseudo-code with a new DAX command YAXISVALUES that shows how I would use this:

    Average Display Value =
    VAR
    Total=
    SWITCH(YAXISVALUES(),
    "SM", SUM('Sales'[Sales ($)]) / DISTINCTCOUNT('Sales'[SM]),
    "TM", SUM('Sales'[Sales ($)]) / DISTINCTCOUNT('Sales'[TM])
    )
    RETURN
    IF(ISBLANK(Total),0,Total)

    See this topic for other use cases: https://community.powerbi.com/t5/Developer/Dyanmically-changing-the-title-based-on-the-drill-down/td-p/33411

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

    We’ll send you updates on this idea

    5 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  17. Cross Drill / Quick Explore Visuals and Tables

    The existing drill down functionality that is available in charts / visuals has to be predefined. I would like the ability to allow users to choose their own drill down path using cross drill / quick explore / dice capabilities that we have in other tools such as Excel. If you right click on an item in a table or chart you are provided with a list of the tables to choose from and then you can select attributes within those tables to drill down / across. Restricting users to a predefined or custom drill down is too limiting.

    The…

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

    We’ll send you updates on this idea

    1 comment  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  18. Multiple Value - Custom List Filter

    A report filter with the ability to copy a list of data, be it numerical or text, from an excel document and paste it into a filter allowing for the visualization to update.

    This would be similar to a Multiple Values - Custom List filter in a competitors visualization software.

    Real world example: If you have a data set that is made up of 100,000 SKUs and you want to analyze a list of 100 SKUs with different attributes, but the only thing you are interested is this custom list.

    If this is already an Idea I am happy to…

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

    We’ll send you updates on this idea

    14 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  19. conditional coloring of line chart based on critical values

    I would like to be able to draw a line chart such that there are two critical values say a and b, the part of the chart above a should be of one colour, part of the chart between a and b should be of second colour and chart below b should be of third colour, also there is a single chart e.g. velocity vs date.

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

    We’ll send you updates on this idea

    8 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  20. conditional formatting intervals

    It would be very useful to be able to tailor conditional formatting by applying users own definitions for intervals.

    Example being:
    1-3,Red
    4-6,Yellow
    7-9,Green
    or
    1-25%, #5956C3
    26-50%, #C356C1
    51-75%, #5C9B9C
    76-100%, #73C374

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

    We’ll send you updates on this idea

    5 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 54 55
  • 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.