on 28 Oct 2016 21:48:31
Please add a better solution/UI to create and manage measures. Measures are the core of what makes Power BI stand out from the rest. At the moment it is quite difficult to find measures (they are listed in alphabetical order with all other database fields. There is no holistic overview of measures across tables and there is no easy way to bulk create edit them. Also it is not possible to see the value of the measure as in Excel PowerPivot. This is a great way to debug your measures by filtering the table and seeing the value change.
I think the ideal solution is a "Manage Measures Dialogue" similar to the Defined Names dialog in Excel.
You have a list of Measures with information about the location, formula, formatting, desxcription and values. You can select multiple measures, rename them, format them, add descriptions etc.
- Comments (7)
RE: Measure management UI
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
RE: Measure management UI
please add "Manage Measures Dialogue" it is very necessary to manage visuals data effectively.
RE: Measure management UI
Have a look at https://github.com/otykier/TabularEditor
RE: Measure management UI
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
RE: Measure management UI
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
RE: Measure management UI
Yes - Manage Measures UI is an critical feature in PowerPivot - should be in PowerBI as well.
RE: Measure management UI
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 :-)