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. Get Path Current File location

    Change Dynamic Path Data Source
    When import data from Folder change dynamic Path Based On Current Path of Pbix File.

    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. M Intellisense for functions but also for PowerQuery Excel

    Intellisense is great, but why not for functions? It would be great to have it also in Excel PowerQuery

    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. 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 →
  4. Add sorting and date hierarchy in financial year (like from April-18 to march-19)

    I have to present data in fiscal year but I got no tool to do that Pls 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 →
  5. Editing Datasets in Power BI Desktop

    We are not able to data model any dataset that is already published to Power BI service. I cannot sort by another column as I can do it if I have a native file import but not for Power BI dataset. We should be able to edit the datasets.

    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. Resizing of "quick measures window"

    When using the quick measures window on a small screen (i.e. laptop), there's no way to resize the window to see the buttons at the end, so the user has to blindly tab through every selection and try if hitting it will finish and apply the quick measure.

    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. Outlier Detection and Elimination in "Edit Query"

    Z-Score (amount of st. deviations from mean for that datapoint) to be used to detect outliers.

    User will input Z-score threshold and rows not fulfilling it will be either filtered or replaced with another value/NULL.

    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. Naming column/field globally

    I'm shocked this isn't already available.

    I hate having to go in each field and replacing the underscore in the column name with space. Especially if there are 200+ fields in the table.

    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. Always show row count at bottom of Query Editor instead of "999+ rows".

    Always show row count at bottom of Query Editor instead of 999+ rows. It's something simple that would make life easier when dealing with larger datasets.

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

    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. Change Query Parameters using Drillthrough (master/detail analysis)

    Change query parameters using Drillthrough capability. Then you can have a Master Query with limited records and a Detailed Query on a data set with millions of records. Query Parameters are then used to limit the Detailed data set dynamically. Currently, you can only change query parameters manually.

    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 →
  12. 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 →
  13. Allow Excel-Like Auto-Fill-Series of Column Header Names

    Allow the user to easily rename a series of columns as can be done in Excel by naming 3 consecutive columns (e.g., B1, B2, B3), then dragging the bottom right corner of the 3 headers to continue the series, creating B4, B5, B6, B7, etc.).

    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 →
  14. Power Query "Merge Column" Code That Is Query Folding Friendly

    Currently in Power Query, clicking on the 'Add Columns' > 'Merge Columns' button and using a custom separator produces M code that is not Query Folding friendly, but it could be:

    Current:
    #"Inserted Merged Column Not Query Folding Friendly" = Table.AddColumn(#"Prior Step", "Merged Column", each Text.Combine({[Column1], [Column2]}, " : "), type text),

    Future:
    #"Inserted Merged Column That Is Query Folding Friendly"= Table.AddColumn(#"Prior Step", "Merged Column", each [Column1] & " : " & [Column2])

    5 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. Allow dashboard users to select parameters that can be read in Columns.

    I know you can have a measure that has a value depend on a slicer setting, but I am a former Tableau customer who has a use case where users selected a parameter that set a column value. That value could then be used in a visual and modified based on the parameter selection. If a user wanted to group by state, they select state, by region they select region, then the appropriate dimension would come into the viz and all measures stay the same.

    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. FORMAT function to return Decimal Type

    The FORMAT / FIXED function allows you to dynamically set the formatting of a decimal field within the DAX formula itself. So its great if you have variable number of decimals or formats you wish to display values in.

    HOWEVER The FORMAT function returns text.
    If the function is used to format a Decimal, Text cannot be aggregated, cannot be used for data bars or sorted in the way a decimal would.

    Converting the TEXT back to a decimal using VALUE removes the dynamic control over the display and moves formatting reliance back to the Modelling Tab. Any flexibility in…

    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 →
  17. FORMAT function to return Decimal Type

    The FORMAT / FIXED function allows you to dynamically set the formatting of a decimal field within the DAX formula itself. So its great if you have variable number of decimals or formats you wish to display values in.

    HOWEVER The FORMAT function returns text.
    If the function is used to format a Decimal, Text cannot be aggregated, cannot be used for data bars or sorted in the way a decimal would.

    Converting the TEXT back to a decimal using VALUE removes the dynamic control over the display and moves formatting reliance back to the Modelling Tab. Any flexibility in…

    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 →
  18. Generar una tabla desde el informe

    Sobre una tabla visual generada en el informe con diferentes campos relacionados de diferentes tablas y campos calculados, generar una tabla de manteniendo esta relación.

    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. Display 'Measure Tables' icon in new Relationship View

    This is a touch pedantic and minor adjustment. In the new relationship view the icons in the 'Fields' section do not indicate if a table is 'Measures Only' or a 'Calculated Table'. It would be helpful if these icons are maintained when looking in the new model view.

    5 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 →
  20. Decouple "Enable Load" from "Refresh Preview"

    My idea is to separate "Enable Load" from "Refresh Preview" so that toggling "Enable Load" option will not trigger "Refresh Preview".

    This will eliminate unnecessary data movement during debugging existing Power Query that need to toggle "Enable Load" on and off.

    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?

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.