Skip to main content
Microsoft Idea

Power BI

Planned

Measure Management & DAX Editor

Vote (7240) Share
DaveG's profile image

DaveG on 09 Jan 2018 10:55:44

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

Administrator on 18 Oct 2022 00:53:09

Update 10/17: This is now in our upcoming roadmap and we will share more details in the coming months. Mo

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 (129)
DaveG's profile image Profile Picture

Power BI User on 05 Jul 2020 23:24:20

RE: Measure Management & DAX Editor

please add "Manage Measures Dialogue" it is very necessary to manage visuals data effectively.

DaveG's profile image Profile Picture

Eugene Niemand on 05 Jul 2020 23:23:20

RE: Measure Management & DAX Editor

Have a look at https://github.com/otykier/TabularEditor

DaveG's profile image Profile Picture

Jack Wells on 05 Jul 2020 23:14:20

RE: Measure Management & DAX Editor

There's a trick you can use to do measure groups:

http://radacad.com/how-to-better-organise-your-power-bi-measures

However would be better if there was a button to create these as this is a very well hidden feature.

DaveG's profile image Profile Picture

Marc on 05 Jul 2020 23:11:08

RE: Measure Management & DAX Editor

This older idea has 500+ votes:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/16783000-measure-dependency-view-similar-to-the-query-depe

DaveG's profile image Profile Picture

Marc on 05 Jul 2020 23:11:08

RE: Measure Management & DAX Editor

This older idea has 500+ votes:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/16783000-measure-dependency-view-similar-to-the-query-depe

DaveG's profile image Profile Picture

DaveG on 05 Jul 2020 23:08:59

RE: Measure Management & DAX Editor

This is very important and what will take PowerBI to the next level regarding productivity. Today most people who use PowerBI daily have a PBIX with 50+ measures and it becomes very challenging to mantain. AT MINIMUM, adding a GUI with a table of listing each measure would be SUPER HELPFUL!

Here is a mockup: https://i.imgur.com/z6TBOQb.png?1

DaveG's profile image Profile Picture

DaveG on 05 Jul 2020 23:08:59

RE: Measure Management & DAX Editor

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

DaveG's profile image Profile Picture

William Gillett on 05 Jul 2020 22:58:36

RE: Measure Management & DAX Editor

Yes - Manage Measures UI is an critical feature in PowerPivot - should be in PowerBI as well.

DaveG's profile image Profile Picture

Ernest Cook on 05 Jul 2020 22:46:18

RE: Measure Management & DAX Editor

I came to the forum to suggest Clone a measure but filtering on measure I see a ton of minor improvements that together could be rolled into this one - create a measure management UI. I only wish I could vote 50 times :-)

Merged Idea (3)