5194
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.

Mockup: https://i.imgur.com/z6TBOQb.png?1
STATUS DETAILS
Under Review
Ideas Administrator

We've been leaning on the community tools like Tabular Editor, DAX Studio, BISM Normalizer, to provide high-end DAX editing capabilities. We don't have any short-term plans to add more DAX management tools to the product, but we'll be looking at ways to better integrate those tools. 

Comments

D

Over a year ago I wrote this, and still there is no progress:

We really need this feature. It is painstaking to have to go through each measure and column one by one, and wait for PowerBI to process changes. In addition, I have to cleanup and reverse engineer many other reports, which often look like spaghetti code, and it's very difficult to click through each. It would save me a ton of time and effort to bulk edit, and see all calc columns and measures in a single window.

I would compare the current setup like writing code, and processing changes after each semicolon, rather than when I compile and execute. I know how all of the columns and measures interact, and how to debug any issues.

Import and export for calc columns and measures would be amazing. Export to something a text editor could open as well, like csv, json, or maybe even excel.
This would allow the group of analysts I work with to easily share standardized measures.

D

Wouldn't if be great if you could write plugin's for Power BI and open up the eco system to other developers. You would get so much more traction.

Dave's design is great. Please improve this area. I use Tabular Editor a lot with SASS Tabular and it's is a much better editing experience than Power BI.

Issues for me.

The Measure editing is very slow and cumbersome and doesn't always accept your edits or new measures.
Set formatting, home table, folder, hidden in one place.
Duplicate / copy & paste measures.
Copy & paste measures across to a different pbix.
Search or filter measures.
Visualise / List dependencies.
Import/export all measures for documentation purposes or transfer to pbix - Although some of this can be done in DAX Editor.
Format the DAX statement.
Refactor the DAX statement with performance improvement suggestions.
Hover over a dependant measure for > 1 sec show's pop-up code view of measure.
Snippet manager that you can store your own measure snippets on a folder.aka Regdate SQL Prompt snippets.

D

Any chance you can include a view that shows which visuals a measure is used in?

D

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.

D

This is absolutely essential. Any update on ETA?

D

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

https://powermeasuresm.wixsite.com/pm-m

D

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!!!

D

Absolutely a must

D

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.

D

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

https://powermeasuresm.wixsite.com/pm-m