Power BI Ideas

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

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

    We’ll send you updates on this idea

    46 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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…

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

    We’ll send you updates on this idea

    30 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.

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

    We’ll send you updates on this idea

    28 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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/

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

    We’ll send you updates on this idea

    22 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  5. 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/

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

    We’ll send you updates on this idea

    22 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  6. 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.

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

    We’ll send you updates on this idea

    36 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  7. Could there be a way to synch data from survey Monkey as well as SPSS

    Enhancing the Power Bi tool to be able to accept data that was initially collected through survey monkey. Is there a way to clean and sort data in the SPSS and then use Power Bi to create your report and share it

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

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

    17 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  9. Introduce a powerful export function

    Right now, Power BI can only export data from the report view to CSV. I would like to be able to export from the "Edit Queries" view to different formats, like CSV, Excel, Access DB, XML, Sharepoint, HTML, etc.

    137 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 →
  10. 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?

    137 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 →
  11. 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.

    132 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 →
  12. 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.

    118 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 →
  13. 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

    109 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 →
  14. Slicer for measures

    Provide a slicer for measures. This means, having the choice to either for example display the actuals or the budget in a given column. It could then be chosen between a various amount of measures to display just some of them in different columns. This safes space on the report and not every measure needs to be calculated and displayed in the report. Thank you.

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

    We’ll send you updates on this idea

    0 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  15. Map conditional formatting

    It would be great, if data on the map could be colored based on conditions. e.g. green if the KPI is achieve and red if the KPI is not achieved...

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

    We’ll send you updates on this idea

    10 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  16. Data Analytics Options- Linear Regression,Logistic Regression, Clustering etc.

    Perform Linear Regression, Logistic Regression ans Clustering Analysis.
    Can generate Statistical values- pvalues, R2, trend line

    105 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. Ability to show quadrants on scatter chart

    Scatter chart could be a much more powerful decision making tool, if we could show 4 quadrants (with background colors and labels) and axis labels (<- Low - Completeness of vision - High ->).

    For example, we can all see that Microsoft is a leader when we look at Gartner Magic Quadrant:
    https://powerbi.microsoft.com/en-us/blog/gartner-positions-microsoft-as-a-leader-in-bi-and-analytics-platforms/

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

    We’ll send you updates on this idea

    7 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  18. Ability to specify custom sort (or order) on the Groups created through UI

    The newly available groups cannot be custom sorted unless additional sort column for this group is added in the model which is not so good. While creating the custom groups, Arrow buttons to move groups Up Down should be available and this order should be used by default sorting unless the user wants to sort asc or desc by some measure.

    97 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 →
  19. Dynamic Constant Line for Targets/Benchmarks

    Allow constant lines in Power BI to be driven by a measure. There is a need to have targets or benchmarks that are dynamic based on other selections on the page and these items could change at different points in time. Currently the constant feature for graphs on the Analytics pane requires values to be hardcoded/entered.

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

    We’ll send you updates on this idea

    10 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  20. Weighted Average

    It would be great if there was a way to create a weighted average. For example, if you have units and prices which vary, it would be great to have a quick and easy way to create a weighted average price when you slice the data. It would basically be a sumproduct of the units and prices divided by the sum of the products.

    80 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 →
← Previous 1 3 4 5 61 62

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.