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.
DaveG
shared this idea
Checking with Will Thompson and moving status to backlog
92 comments
-
Anonymous
commented
Any chance you can include a view that shows which visuals a measure is used in?
-
Evan
commented
A M A Z I N G.
And solves so many annoyances, adds so many features, and it's literally just some UI/UX implementation. CRITICALLY REQIUIRED.
-
Anonymous
commented
This is absolutely essential. Any update on ETA?
-
PMM
commented
There is a new app named PMM (Power Mesures Manager) that dose just this
in this link you can read all bout it and download the App for free -
Dan DeHaven
commented
I absolutely love this idea and every day I find myself wishing the Measure editor was better in the ways that have been listed. I was just spending a fair amount of time yesterday in the Excel Name Manager and thought that the same type of tool would be great in PBI as well. Also, the current editor is so clunky, to have a Visual Studio style editor with line numbers and better controls over the size as I'm constantly fighting with it opening to nearly the full screen. I'd love to be able to drag the size to a sticky setting.
A large portion of the time developing PBI solutions is in the Measure editor and it really would be a huge efficiency gain to get a more robust editor. Thank You!!! and Please!!!
-
Hew
commented
Absolutely a must
-
Anonymous
commented
There are already some great comments on this, but just wanted to reiterate that having a pop up window with enhanced syntax highlighting, find and replace and the ability to enter and tab and all of that without the editor trying to exit would be amazing. Also would be really cool to have all the measures right over in a sidebar that would allow easily selecting and modifying other measures. Supports for repository / favorites / templates / snippets would also be a really cool feature.
-
pods
commented
For the past 10 years GBH POPPY PODS has shipped finest dried poppy pods and other interesting dried products for all of your crafting needs.
The dried poppies we carry are a naturally grown product, and vary greatly in size, although we would love to size each and every order, because of our speedy shipping, we simply don’t have the time. We do sell by weight however, by the 1/2 pound and 1 pound. We guarantee the weight of your order will be “on the dot” or even a little heavier. you can buy poppy pods in USA, poppy pods for sale in Canada and all other countries that do accept poppy pods products
-
PMM
commented
There is a new app named PMM (Power Mesures Manager) that dose just this
in this link you can read all bout it and download the App for free -
Rose Ventura
commented
It would also be nice to be able to easily copy measures from one report to another. I sometimes use the same measures over multiple reports. If there was a repository where measures could be copied/maintained, it would make it a lot easier to use many measures over many reports.
-
Anonymous
commented
This is so fundamental. Please do this Microsoft.
-
Jon
commented
9 months and no update for an idea that's #4 on the Top list with 4,000 votes. Idea submitted almost 2 years ago.
-
Viral Tarpara
commented
The lack of centralized measure management a key gap in PBI’s ability to act as an enterprise semantic layer. Compare PBI to how Looker, Qlik, Domo, or GoodData treat this issue as a starting point. Get this right and people will be dropping their SAP BO tomorrow.
-
Tomislav Mališ
commented
This is one of most important things to have. Clients do not understand that we can't do bulk changes or migrations of measures.
-
Kulchandra Neupane
commented
When we work on copies of powerbi and there is minor change in dax but we don't have find replace command for it. It takes too long to go to each dax and make changes.
-
Anonymous
commented
This would be great!, I would also add the possibility of manually evaluate a portion of the DAX formula for previewing the result (like we can do with F9 in excel)
-
Arklur
commented
This would be a huge QoL addition to the tool, I hope it will be implemented soon :).
-
Oliver
commented
Would love this. I'm in the same boat. PBIX file(s) with dozens and dozens of measures and it is unbelievably painstaking to make mass edits to them.
-
E A Misemer
commented
What does "backlog" mean?
-
Pro Documentation
commented
Thanks for the information . am glad to be part of this community .
yours
https://pro-documents-online.com/