How can we improve Power BI?

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.

Mockup: https://i.imgur.com/z6TBOQb.png?1

3,748 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

DaveG shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

83 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Daniel Otykier commented  ·   ·  Flag as inappropriate

    For measures alone, you can actually use Tabular Editor https://tabulareditor.github.io/, although it is unsupported. Tabular Editor lets you connect to a running instance of Power BI Desktop, or to open a .pbit file. You can also export/import measure properties (such as format strings, descriptions, expressions) to a .TSV file for batch editing in Excel. See https://github.com/otykier/TabularEditor/wiki/Useful-script-snippets#export-object-properties-to-a-file for more details.

  • William McNAir commented  ·   ·  Flag as inappropriate

    ALso would be a good idea to include the ability to check mark which measures should be active. If you dump a copy and paste set of measures from another workbook, you don't want them all to try and resolve to the new set of data tables until you have made the necessary changes to table and column names. Also, a search and replace function for this formula management area would be welcome.

  • TEEGEE commented  ·   ·  Flag as inappropriate

    > Imagine needing to create 50 measures: currently you need to press "Create new measure" and edit the formula each one at a time. With this proposed design you can create them once in PowerBI OR quickly in a table in Excel, and then simply paste them all into the existing PBIX or any other going forward.

    The ability to paste a whole bunch of measures all into one window (the ability to specify the home table where they will reside would be nice too) would be a KILLER feature for me!!!

    Amazing mockup by the way OP.

  • Didier commented  ·   ·  Flag as inappropriate

    Great idea !
    Until it will be implemented in Power BI desktop, I share my way to search a string in DAX columns and measures :
    https://community.powerbi.com/t5/Desktop/How-to-search-a-string-in-all-DAX-formulas-of-a-Power-BI-desktop/m-p/363257#M164141
    This method is not supported by Microsoft but it is very useful. You may even search in different reports and export formulas to Excel easily.

  • Ben commented  ·   ·  Flag as inappropriate

    Also, please add a feature to show "Unused Measures". That will help a lot with cleanup.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Great work on the mockup. TBH I don't know why Microsoft doesn't implement this and let it be the editor for Analysis Services models as well (though there are still missing features). Convert Power BI Desktop to an Electron app and build some integrations with Azure!

  • Olivier Travers commented  ·   ·  Flag as inappropriate

    Really nice Work DaveG with your mockup. This is a good example of how PBI Desktop's UI doesn't scale well with volume.

  • Anonymous commented  ·   ·  Flag as inappropriate

    I think display folders should be included in "measure management." This feature is already available in the Tabular model -- Power BI just does not utilize it. You can manually script it into your Power BI models but it's not supported OOTB.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Very good idea, the process of adding and changing measures is way to tedious at the moment. I really hope this get's picked up quickly.

  • DaveG commented  ·   ·  Flag as inappropriate

    Great point Michael! What may also be handy is to have a toggle like in Excel to temporarily disable re-calculations until all your edits are done. This way you can make all your edits and not have to wait for the model to re-calculate after each edit.

  • Michael commented  ·   ·  Flag as inappropriate

    Great idea! Plus creating a new measure in my model takes over 3 mins before I can start typing. Imaging if I make a typo or syntax error on top of that? Im pushing 8-9 mins if I make a mistake.

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.