Power BI Ideas

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. multi select columns in relationship view

    Ability to multi-select columns in the Relationship View of the Power BI Desktop to hide items in bulk. This works now in Power Pivot for Excel but not in the Power BI Desktop.

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

    We’ll send you updates on this idea

    3 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  2. Support Group Policy and WSUS / SCCM Updates

    The application should have the ability to be deployed / updated like any other Office Package, either via the Office 365 Pro Plus CTR approach or traditional patching. It should also respect Group Policy for control of user settings and ability to disable features that may infringe corporate security policies.

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

    We’ll send you updates on this idea

    13 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  3. Collapse/Expand all tables in Field List

    A button to collapse and expand all of the tables in the field list would be a great enhancement to the UI, particularly for models with a lot of attributes and measures. Currently it can be a chore to scroll through all of the attributes to find the collapse/expand arrow for a given table when you want to quickly navigate between other dimensions.
    Potentially there would be two options for collapsing/expanding just the Measure groupings and just Tables.

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

    We’ll send you updates on this idea

    0 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  4. Show text as values in a matrix

    We have a need to show text in the values section of a Matrix. We are tracking product distribution and need to place the distribution code (technically text) for a product with a specific customer.
    Here is the setup:
    Rows - Product information
    Columns - Customer names
    Values - Distribution code

    Thank you!

    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  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  5. Add global variables to DAX

    I am calling them global variables, because "Measures that can return tables" ... probably confuses too many issues.

    Say I have a custom calendar with exactly 52 weeks per year.

    Prior Year := FILTER(ALL(Calendar), Calendar[WeekNum] = MAX(Calendar[WeekNum] - 52))

    ^^ Not valid today.

    If it was, I could then do...
    Sales - PY := CALCULATE([Total Sales], [Prior Year])
    Profit - PY := CALCULATE([Total Profit], [Prior Year])

    Maybe:
    VAR Prior Year := FILTER(ALL(Calendar), Calendar[WeekNum] = MAX(Calendar[WeekNum] - 52))

    And call it a "global variable" or Table Measure or ... something?

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

    We’ll send you updates on this idea

    14 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  6. 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  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  7. Undo functionality for 'Unhide All' columns/measures option

    There is an option in Power BI designer to 'Unhide All' columns/measures. A couple of times, because of my fat fingers I clicked it and there was no way to go back. There is no confirmation window neither. There should be an option to undo such changes. In my case, I had to spend around 30 min hiding the columns/measures that are unnecessary in the report view.

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

    We’ll send you updates on this idea

    2 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  8. Password protected query and report

    I need to protect our SQL query so that no one can view or edit it (or change the server address), but leaving to the users the possibility to edit visuals and datasets (password protected gear icon in the query editor). It would be also useful a lower level password protected .pbix. We need to know if Microsoft is going to develop something like this in order to permit us to develop some heavy queries on our database structure. I found Power Bi Desktop very intuitive, but much less secure than Excel, passwords, macros, permission levels would provide great improvement.

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

    We’ll send you updates on this idea

    1 comment  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  9. KPI "Different id bad" status option

    KPI "Different id bad" status option or possibility to define values to turn green or red.

    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  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  10. Measures/Metrics Name as Selector

    How about adding option to make a metric/measure as selector. Actually, it will be only metric name which will serve the purpose of selector and you can give user option to switch to different measures by looking at same graph.

    One example is Sales $ and Sales Unit by months. In current options, if you want to place both measures in a dashboard you either need to add two graphs, one for each. Or you can add both measures in same graph by using line and bar chart. Having measure name as selector, you will have option to change your…

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

    We’ll send you updates on this idea

    3 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  11. Create SSRS report within Power BI Desktop

    It would be nice if we can create SSRS report within Power BI Desktop.

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

    We’ll send you updates on this idea

    1 comment  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  12. 막대차트의 X,Y 축 텍스트 크기를 조절할수 있게 해주세요

    막대차트의 X,Y 축 텍스트 크기를 조절할수 있게 해주세요

    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  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  13. multiple target

    I would like to be able to add more than one target line to a visualisation, and also to be able to add variable target lines (e.g. Year on Year or targts that change over time).

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

    We’ll send you updates on this idea

    1 comment  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  14. export custom table

    Give the ability to export and input custom table with all fields. This could save a lot of time for date dim tables.

    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  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  15. Conditional Formatting table based and not column based

    If I refresh the table and new column added I want the formatting on the new cell...

    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  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  16. 6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  17. 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  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  18. Support for user-defined R library

    When running SQL 2016 With both R-Services and Microsoft R, I usually download all custom packages to a seprate Library, e.g. c:\rlibs and change the libPath to include this

    > .libPaths()
    [1] "c:/Rlibs"
    [2] "C:/Program Files/Microsoft SQL
    Server/130/R_SERVER/library"

    R data Source and R Visuals only look at the Library under program files when running and will effectively ignore what I've downloaded to c:\rlibs.

    Please add support for custom Library paths to avoid us having to elevate to admin before installing packages into the program files folder.

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

    We’ll send you updates on this idea

    1 comment  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  19. Improve Direct Query Date Time Handling

    When using direct query you should be able to change a date axis to show only the month. This works using excel or when doing a transform but neither of these are possible using DirectQuery. Even workarounds like FORMAT can't be used with direct query. This really needs fixing!

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

    We’ll send you updates on this idea

    47 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  20. Modeling and Advanced Query options in Microsoft Analysis Services Cubes support

    Power BI have modeling and advanced query options for SQL Server datasources, but I can not use similar functionality for MS analysis services cube datasources, Do I miss something or this MDX lecel querying and modeling options are not ready for Power BI desktop yet ?

    I use, custom column generation and then sort this column using another data column in Power PI modelling feature for SQL server dataset but it is not possible for analysis services cubes datasets.

    Any comment or workarounds are apprecciated.

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

    We’ll send you updates on this idea

    0 comments  ·  Desktop  ·  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.