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,139 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 →

    71 comments

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

        It's a great idea. If Dax editor looked like MDX editor in SSAS I would be happy

      • Anonymous commented  ·   ·  Flag as inappropriate

        This is the capability that I have been waiting for , for some time,,,, very nice work on the mockk up

      • William McNair commented  ·   ·  Flag as inappropriate

        Does moving to "Backlog" mean this feature suggestion go to the head of the line or does it get thrown into the back of the line never to be seen again. If the latter, how can we indicate that it is a very much needed feature? Is there a similar request in a different area?

      • jsp.almeida1983 commented  ·   ·  Flag as inappropriate

        Please Please advance this feature asap. Entire world will thank you so much. I’am sure of that.

        Happy 2019!!

      • Russell Price commented  ·   ·  Flag as inappropriate

        Trace Dependencies is a BIG issue that would be very helpful. It would also be awesome if the editor was available to use while in the relationship view. It is helpful to be able to see the relationships when writing the formulas.

      • Felix Becker commented  ·   ·  Flag as inappropriate

        + a type ahead functionality would be a plus, or kind of "auto fill", e.g. start typing "calc" than press e.g. "Tab" and the editor propose results, like "Calculate".
        + a formula checker (like others already suggested would be great.

        I support entire idea. What a great effort DaveG. Thank you. Hope to see something similar soon.

      • Jonathan commented  ·   ·  Flag as inappropriate

        The mockup looks fantastic, I can't believe they haven't even started to implement this yet.

      • D. Pearce commented  ·   ·  Flag as inappropriate

        This is a critical issue that is keeping me from migrating several business critical reports from Excel to PowerBI. Having maintained this data for over 7 years, we followed the progression of PowerBI from it's early origins in PowerPivot, creating tons of custom measures with both complex relationships and DAX formulae in their Data Models.

      • Anonymous commented  ·   ·  Flag as inappropriate

        What? W don't have advanced editor in Power BI? Oh come on...I was about to ditch Excel for Power Pivot and now I have to go back...

      • Marcelo Silva commented  ·   ·  Flag as inappropriate

        Best mockup I've seen!! In a fully centralized data storage, a variable/measure that depends on native fields can be dragged across to other PBIX just as natural and whether the new pbix consumes the same native fields then it can attempt the calculation.

      • Tim Heng (Excel MVP) commented  ·   ·  Flag as inappropriate

        Brilliant idea, great mockup that clearly highlights the benefits. The only thing you're missing in the DAX Editor is a "check formula" button. I also suggest that you cross-post this into the Excel Uservoice site as well, because the Excel measures interface, while better than the existing Power BI one, could also be improved in this way.

      ← Previous 1 3 4

      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.