Power BI Ideas

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Grouping/Aliases

    It would be great to have the ability to "group" data points and give them an alias. An example would be to group specific customers together to compare to one big customer.

    This is available in Tableau and should be on Power BI!

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  2. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  3. Add more detailed Power Query refresh icons

    For all Power Query objects in the "Query Editor" window, add icons for "refreshing" and "error" states for each query object.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  4. Verbose "Power Query" editor execution status

    Provide a panel in the "Query Editor" window that displays real-time verbose steps being taken by the Power Query M Engine so as to permit real-time debugging and performance tuning.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  5. Relationships

    Managing Relationships

    Classification of relationships-allow categorizing the tables (fact or dimension).

    In the Relationship Management environment make the option to categorize the tables by fact or dimension and include a tag indicating the color. Visually gets more facial to manipulate the relationship tables and creates a universal language so always We know when it's a fact table and dimension.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  6. Allow "Select All" option within the slicer after filtering some letters

    Let's suppose I've a lot of data to show as a list in a slicer. After setting a first filter with some letters, I'd like to click on "select all" option to include all the elements found in my search

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  7. Conditional batch replace in single step

    Wish to do multiple replaces in a single step similar to the conditional column step.

    Wish to have multiple conditions here too

    EG Value = 'D' where value in Column 2 starts with 'X' and value in Column 3 is 123

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  8. Make it Easier to calculate variances between two columns in matrix visual table, without having to create multiple measures

    Often we have a summary matrix visual and we just want to do variances between the two now the filters on the table can be quite complex meaning the measures just do the simple calculation of summary matrix column a - b becomes complex due to filter context

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  9. Add Phone Number as a data type or category

    Adding a phone number as a data type or category so that Power BI can easily interact and manipulate phone numbers into different display formats

    Ex:
    (123)-456-7890
    (123) - 456 - 7890
    123.456.7890
    1234567890

    And treat all the same so that if a user searches using one of those formats, no matter how the data is actually stored that it can find anyone of them.

    Could also map the area code to geographical locations too

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

    We’ll send you updates on this idea

    1 comment  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  10. Preview downloaded should show time of query refresh, not just time of finish

    I mean it should show the difference between end query time and start query time, and not only time of finishing of downloading the preview.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  11. "There's already a relationship between these two columns" - tell me what the relationship is

    When creating a new relationship between two columns sometimes Power BI returns this error - "There's already a relationship between these two columns". Please can you add a feature to tell us what the conflicting relationship is?

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

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  12. Fix the action around Formula.Firewall so instead of a weird error you get prompted with something actionable

    PowerQuery throws this odd error in some cases when a query references another query. Instead of the error, it should prompt you to select the correct privacy setting.

    Formula.Firewall without Ignoring Privacy Levels? Query 'x' (step 'Source') references other queries or steps and so may not directly access a data source. Please rebuild this data combination

    Questions on this come up repeatedly in the forums. See two discussions here:https://social.technet.microsoft.com/Forums/en-US/ee1381f7-c919-4134-be96-5f06dbdb9cd5/how-to-fix-formulafirewall-without-ignoring-privacy-levels-query-x-step-source-references?forum=powerquery

    And from 2015!
    https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/

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

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  13. calculation options

    Add "Calculation Options" of "Automatic" and "Manual" like one in Excel.

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

    We’ll send you updates on this idea

    2 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  14. Identify missing join values

    Recently some Column Quality and Column Distribution checks have been introduced into the Query Editor, which are great.

    A useful addition would be identifying Foreign Key values for which there's no corresponding Primary Key. A simple and common example of this would be identifying Customers who appear in the Sales fact table who don't appear in the Customer dimension table.

    The join created by the developer would identify the Foreign/Primary Key relationship, and perhaps any such orphaned Fact table records could be highlighted against the join itself.

    Currently such occurrences of this will usually result in Sales values posted against…

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

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  15. Custom sorting in PowerBi service

    Really necessary thing which cannot now in Service version.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  16. Permite mostrar conceptos de diferentes categorías en filas

    Mi empresa es de supermercados, Seria ideal que BI permita mostrar conceptos de diferentes categorias en filas y que en columnas muestre semana,mes,trimestre, año. Imaginar montar un presupuesto de una empresa en esa vista, tipo FORECAST 1,FORECAST 2,FORECAST 3,FORECAST 4, donde por filas muestre, ventas, margen, %msv,% de las perdidas, cifra de las perdidas conocidad y desconocidas,el grupo de un balance perdidas y ganancias, % el ratio de gasto de personal,el ratio de rotacion de personas de rrhh,las secciones de carnicerias, charcuterias,fruterias, o a nivel sector agrupado,

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  17. Change Query Parameters using the URL in powerbi.com (master/detail analysis)

    Change query parameters using the URL. Then you can have a Master Report with limited records. And a Detail Report with a Query on a data set with millions of records which is limited by a Query Parameter. Passing the Parameters with the URL can then limit the Detailed data set dynamically. Currently you can only pass filters, which will limit data only after query execution.

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

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  18. News features

    Add an option that allows you to convert the contents of a Table from the Reports View directly to the Data View, instead of using Export to csv.

    Add to the Replace from Query Editor option, replace with a value from another column.

    Add auto increment column in a Report View.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  19. News features

    Add an option that allows you to convert the contents of a Table from the Reports View directly to the Data View, instead of using Export to csv.

    Add to the Replace from Query Editor option, replace with a value from another column.

    Add auto increment column in a Report View.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  20. Is it possible to perform multiple arithmetoic operation on a single column

    I am able to find hte sum of a column value depend on category but I also want ot divide it by 100. I am not getting this option. Can you please help.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  • 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.