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
133 Comments
- 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 :-)
- Yes - Manage Measures UI is an critical feature in PowerPivot - should be in PowerBI as well.
firstredpepperAdvocate II
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- firstredpepperThis 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
- 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
- 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
- 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.
- Have a look at https://github.com/otykier/TabularEditor
- please add "Manage Measures Dialogue" it is very necessary to manage visuals data effectively.
- A simple way around this is to create an empty table in power bi, name it _Measures so it appears at the top and then create all your measures in this. I have multiple tables when I need specifically named Measure Groups
