Power BI Ideas
-
Copy/Paste from Power BI Desktop
Please allow Copy/Paste functionality from Power BI Desktop. We often need to recreate PBI reports in Excel just so we can Copy tables or charts and paste into PowerPoint or simply email it. Need stronger integration with other Office products. Copy/paste seems so basic.
Note: Our company uses PBI Desktop and PBI Report Server (on SQL server) - cloud services are not an option because of Protected Health Information.
1,204 votesWe are working on adding features that let you easily copy data out of Power BI and into other applications. Stay tuned for more updates on this!
-
Composite models when connected to SQL Server Analysis Services Tabular (SSAS)
We really love the new feature of 'Composite Models' in the Power BI July 2018 update! This enables us to join custom lists with DirectQuery sources.
It would also be beneficial if this would also work when connected to SSAS Tabular in DirectQuery.
This would stronlgy improve the enterprise features of Power BI.240 votes -
Measure Management & DAX Editor
Anyone who uses PowerBI long enough has had a PBIX with 50-60 measures and it has become time consuming and tedious to mantain. In Excel you can do a quick find/replace to edit several formulas - in PowerBI you need to select each one individually. An "excel-like" interface for editing measures would save a lot of time! This would take PowerBI to the next level regarding productivity. I've prepared a mockup for this as well as a DAX Editor. Let me know what you think.
2,412 votesCertainly a great idea. Please keep the votes coming.
-
Organizing Measures into Categories using Folders
Adding few measures to your data model in PowerBI could be easily managed, but what about adding tens or even hundreds of measures! Organizing those measure into categories using folders could help a lot.
To show you what I exactly mean, I will demonstrate the alternative way to create those folders using empty tables:
1. Select "Enter Data" from the Home ribbon > Change the column name to "Id" and choose the table name e.g. "_Financial Measures" (Create all the tables)
2. Select "New Measure" from the Modeling ribbon (Or choose any shortcut) > Type and create a new measure…150 votes -
Power BI collaborative development
allows multiple developers to work collaboratively on the same PBIX.
Idea could be separate back-end (advanced editor) and fron-end (modelling and report design) or allows the possibility to merge more than one pbix.
264 votes -
Eraser for Search in Slicer gone if Header hidden
if you turn off the Header for a slicer with text in the field, the eraser vanishes from the Search box so there is no way to clear it. Turning on Titles doesn't fix it either. You must leave the Header on.
Seems like a bug.
119 votes -
Report page tooltip on all objects
New report page tooltip preview feature in the March update is great.
Would be nice if we had the option of adding this tooltip to visuals that previously didn't have a tooltip.
For example, I have a card visual. I'd like users to get one of these mini report pages pop-up when they hover over it but as this visual doesn't have a tooltip it can't be used.
Would be great if we can do this on other things like shapes and text boxes as well.
351 votes -
IntelliSense Should Use Best Practice Column and Measure Naming Conventions
There is a clearly defined and accepted best practice for referencing columns and measures in the DAX language.
1. Column names should ALWAYS reference the table name.
TableName[Column Name]
2. Measures should NEVER reference the table name.
[Measure Name]This is a fundamental concept accepted by everyone with knowledge of the DAX language (everyone I know anyway).
IntelliSense in DAX sometimes follows this convention and sometimes it does not. I have created a short video (40 seconds) showing 3 examples. https://youtu.be/CvaRhKrnHRk
There are other places where column names are appended to measure names too, such as inside Quick Measures, and…
248 votes -
Organization Approved Themes
Now that themes are out of preview and the Product Team has included themes in the Desktop tool the next thing to add to this is to have a section for organization approved themes. Since many companies have branding guidelines this would be an easy way for admins to load these themes and allow end users to pick from them to create consistency.
23 votes -
Click and Drag to Select Multiple Objects and Allow Nudge
Similar to the other Microsoft products, it'd be great if we could click and drag the mouse to select multiple object on a page. Then, once multiple are selected, allow us to nudge them with the arrow keys all at the same time. Right now, we have to click one at a time and nudge one at a time. Oftentimes, I have many items I've already spent time aligning and then I need to nudge them and I have to do it one at a time.
37 votes -
disable auto time intelligence
Make the "Auto Time Intelligence" feature a global option that can be turned off for all subsequent PBIX files.
76 votes -
Allow Slicers to be preset based on defined criteria
Allow Slicers to be preset based on defined criteria (i.e. DAX formula or other developer input).
For example, a dashboard that displays KPI data based on the current week end date. On displaying the dashboard the screen should default to the current end date with the user having the optional ability to set the date slicer for previous weeks.
At a stretch you could have a button with a bookmark action to run some DAX that could set the date slicer to the latest end date.
Taking this further you could also reverse and forward the slicer to the next…
24 votes -
(Real) Dual axis charts
It would be nice to be able to create dual axis charts and not the combo chart, to be able to drop more than one value on an axis and synchronize those axes. It would also be good to be able to control the type of mark in this instance so you could have one bar and one hash mark. Stephen Few would be happy cause we could create bullet charts (yeah those custom visuals really don't work and have bugs)
26 votes -
Implement Power BI on Mac
Implement Power BI, and Office extensions on Mac OS
26 votes -
Conditional Formatting for Text
It would be great to conditional format a table and/or a matrix based on the cell text, not only numbers
870 votesThis month we added the ability to format text fields based off a numeric field: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2018-feature-summary/#conditionalFormatting
We also are planning on adding a feature that will let you format your text based on comparisons. I’ll update this idea based on our progress on that feature.
-
Export PowerBI Desktop report to pdf, word, powerpoint
Export PowerBI Desktop report to pdf, word, powerpoint
157 votes -
Allow bookmarks and bookmark folders to be exported to pdf
The Export to pdf functionality allows us to export or print the report pages. But it would be nice if we could also print/export the bookmarks (all of them or just a folder/group)
12 votes -
Adding Comments
In a PBI report published on the PowerBI Server we can add comments. However I have always felt that the functionality of comments should be attached to a Bookmark rather than a report. A bookmark is really the'view' which I am seeing and sharing and on which I could like others to know of my thoughts.
Urging MS to add the functionality of adding comments to Bookmarks on the PowerBI service also asap.
19 votes -
Change log for Power BI?
It would be good life Microsoft would provided a list of changes in the PowerBI Desktop
12 votes -
KPI Color Coding customizable
The color coding has some bad effects for us.
We simply want to show if something is under or over budget.
The custom visual Cards with states by OKViz does it right for us, but the goals are missing.For example we are 1.2 mil of costs under budget of 2.4 millions. That should give a green color. But if we are for example 40'000 above budget it still shows green. But the business reality is that 40'000 over budget is red. So for our business it is wrong. The truth should be under 0 is green. Over zero it…
16 votes
- Don't see your idea?