Power BI Ideas

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. modeling - currency formatting

    I have a difficulty when I have decimal data and need to turn several columns into unit.

    Improvement Ideas:
    1 - Favorite or choose the ones that should be at the top, in my case I have to select column by column and search among so many units that have.

    2 - Select multiple columns and format at once. Ex: Decimals direct to real currency R $.

    3 - Or, formatting princel to replicate this same currency unit format

    4 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 →
  2. Distinct Count summarization in Manage Aggregations

    When defining aggregate tables using the "Manage aggregations" dialog, there is no option for mapping an aggregated column as the distinct count of a column in the source table.

    This causes all DAX queries using DISTINCTCOUNT to use the source table instead of using the aggregated table. In order to improve performance, we'd like this option to be added.

    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. Power Query - Visually indicate native query steps

    Add a little icon for native query steps so that we are instantly aware which steps uses native query and where native query "breaks"

    Not I have to right click every single step to get this information

    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. Visual Process Flow in Power Query

    The Power Query editor should have the ability to switch back and forth to a visual diagram.

    I love stepping out M query - but I find when teaching end users that have used other data prep or ETL tools they are used to a visual diagram.

    A visual flow allows you to show relationships to other queries/sources and in some ways can be more intuitive to users.

    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. Field formatting multiple data types in a table

    In the field formatting section of a table, allow users to be able to change the data type of the column. Example: I have a custom selected measure that will give the results for both Sales or Units depending the selected slicer choice in a table. I need to have the Sales in currency format and Units in a whole number but cannot have both currently, only one of the other.

    9 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 →
  6. More evident LOAD/NOT LOAD format in queries list

    It's sometimes hard to spot which of your queries will load and which not. The cursive format is not evident first look and requires a bit of visual 'effort'. Maybe a nice Prussian blue font colour?... but that's my preference ;)

    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 →
  7. Include Count and count distinct like quick measure

    Those are two most of tipical measure with data.

    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. previous few days, monthes, quarters, years function

    It seems like a good idea to add functions like PREVIOUSFEWMONTHES (<dates>, <period> number), days, years, quarters.
    it should work completely the same as PREVIOUSMONTH but return a data from defined quantity of previous periods

    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. New Data Category: Key

    There needs to be a new data category to identify table columns that behave as Key field. A key field shows the following characteristic:
    1) It is never displayed in a report.
    2) It is never null, empty, or ' '.
    3) It is a unique value when a primary key, duplicates when a foreign key.
    4) It is always indexed for quick matching (JOIN) to it's corresponding index in other tables.

    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 →
  10. By default sum of _measure.

    If we drag _measure in canvas, then by default power bi will make it SUM.

    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. Allow Determination of Environment

    I would like to obtain Workspace name and when modeling (in M). I would also like to be able to determine whether running locally (Desktop vs Service). About the only environment settings one can currently ascertain are local time and userprincipalname.

    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. Data type in Power Query custom column

    In the dialog box that appears when you create a custom column, there should be a drop-down box where we can select the desired data type of the new column. As-is, we have to add a second step specifying data type or manually in the formula bar/advanced editor type ", type text" or whatever; it would be far more convenient to be able to do that right within the dialog box.

    4 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. relationship with wildcards

    Would like to have the functionality that you are able to build a relationship using wild cards, eg:

    Dimension:
    Key: P001Y2GT7777
    Key: P001
    **********

    FACT:
    Key: P0011Y2H22323GT6543

    The relationship to take into consideration the wildcards so that I can classify a line item to multiple times.

    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 →
  14. Make code generated by Power Query UI less dependent on hardcoded values

    All the code generated using the Power Query UI is so literal, it feels like I'm interacting with a dumb kid. If I'm selecting all columns and, say, trimming them, why hard code all the column names? It makes code hard to re-use and brittle, which generates a lot of menial code editing overhead.

    Instead I would like PQ to try and generate more generic code. I'm sure combining soft coding with code generation is a hard problem, but this would have so much more impact on the productivity of Power Query developers than sinking resources into yet another sentiment…

    11 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. ROUND function calculates wrong value

    When ROUND(51,24999999999;1) is executed, this results in the value 51,3 and not in 51,2 what I expect.

    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. Promote selected headers only

    It'd be nice to promote the first row into headers but only for specific columns.

    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 →
  17. Change "owner" on shared dataset

    For shared and certified datasets, we would like to be able to change the "owner" information to the data steward of the dataset, i.e. the person who certifies and controls access to the data. Currently the "owner" shows up as the person who published the dataset - which isn't appropriate for production datasets that are published by IT.

    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. Rename query steps without refreshing preview

    While renaming query steps (right-click rename OR right-click properties) when you apply the name change, it will re-run the query step. Why? Best practice to rename query steps yet for very large data sets this becomes cumbersome during the queries initial development. Note: I could be missing something valuable that would prevent this, please advise.

    15 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 →
  19. Execute a Quality Check query before refreshing the dataset

    Provide an option to do a quality check query before refreshing the dataset. This avoids data accuracy to production reports.

    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. Option to Record Applied Steps (similar to VBA)

    Data preparation is most time consuming task for an organization. If Power Bi comes with a feature where we can record earlier applied steps and repeat it for recurrent updates in the data, it will be a great use of Power BI. Microsoft can create something similar to what it has done with Excel VBA

    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.