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

1,546 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    41 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • James Cronin commented  ·   ·  Flag as inappropriate

        I love it! But definitely needs grouping! It's so hard to keep things organized for my own use, let alone collaborating with others on dev. I have well over 100 measures in a couple of my pbix files, and while strict naming conventions help, mine seem to render the Q&A useless.

      • Anonymous commented  ·   ·  Flag as inappropriate

        We really need a revamped DAX editor soon -- or at least let us expand the current DAX editor window. It doesn't suit large statements well.

      • David Pitts commented  ·   ·  Flag as inappropriate

        Actually All we need is the ability to separate the Model from the data from the visualization in the PBI.

        I already use Excel, Power Query the PowerBI Object Model and VBA to Author my Data Models in Excel in PowerPivot. (800+ Measures!) from standard analytical Patterns

        I use he Import from excel in Power BI Desktop to Bring the mode into PowerBI. and then To Service

        The Problem is that once this is done and you create the Visualization Layer, you cannot go make and make major changes to the Model without recreating the Visualization Model. either way the maintenance of the Model is Time Consuming and Tedious which ever way you go rom there

      • Anonymous commented  ·   ·  Flag as inappropriate

        Do you need an urgent blank ATM CARD to solve your financial needs, My name is Linda Oscar, and i just want to tell the world my experience with everyone. i discovered a hacking guy called Christopher. he is really good at what he is doing, i inquired about the BLANK ATM CARD. if it works or even Exist, than i gave it a try and asked for the card and agreed to their terms and conditions. three days later i received my card and tried it with the closest ATM machine close to me, to my greatest surprise it worked like magic. i was able to withdraw up to 6000 euro. This was unbelievable and the happiest day of my life. there is no ATM MACHINES this BLANK ATM CARD CANNOT penetrate into it because it have been programmed with various tools and software. it impossible for the CCTV to detect you i don't know why i am posting this here, i just felt this might help those of us in need of financial stability. Christopher have really change my life. if you want to contact them, HERE is the email address: (blankatmcard661@gmail.com) His website (http://blankatmcard661.wix.com/blankcard)

      • Anonymous commented  ·   ·  Flag as inappropriate

        This would help with visibility to our expressions too. I'm always looking back through expressions to see what other fields were referenced and it is very time consuming. Half the time, I feel like I am blind, while working on new expressions. I'd love to be able to see them all simultaneously, especially when one must be calculated first and then another and another. It would help to be able to see all of them at once to see the flow.

      • Rose Ventura commented  ·   ·  Flag as inappropriate

        While you're at it, it would be great to create a repository or library where you can export your Dax measures and share them among your many dashboards. So often I find myself creating the same measures over and over (not from scratch but thru copy paste). I started copying my measures into Excel and then keep that as my repository, but it would be great if we could "Export measures to library" so we could share. To see all measures that you've created in one place would be great!

      • Wildmight commented  ·   ·  Flag as inappropriate

        This will definitely help to speed up development. Especially during tedious copy/paste - change column/metric name in formula!

      • Stéphane commented  ·   ·  Flag as inappropriate

        You could develop a graphical interface where formulas are boxes with inputs and outputs and links to data tables and other formula boxes! See software like Blender 3D (Nodes) or 3DSmax! It's so boring to learn a language for every application!
        When will Microsoft take the step of the 90s in terms of user interface?

      • David Cresp commented  ·   ·  Flag as inappropriate

        Sounds like a great idea. Some of the great features of DAX Studio could be brought into the DAX editor.

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

      ← Previous 1 3

      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.