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

    59 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • 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.

      • Billy commented  ·   ·  Flag as inappropriate

        Very good idea; only thing I would add is some kind of mechanism to bulk-format measures i.e. if you've just made 10-20 measures and they all need to be a specific format (#,# or #.#%) you can select them and apply to all.

        Would save a lot of time rather than clicking on each and updating or hard-coding the format in the DAX.

      • readydocs702 commented  ·   ·  Flag as inappropriate

        We are the best and Unique producer of 100% Super Undetectable Counterfeit Banknotes, SSD chemicals for cleaning black money and International Documentation Services like Fake and Real Driver's License, Certificate of Nationalization, Fake and real ID Cards, Fake and Real Passports and also provide Documents duplicating and Erasing Criminal Records. Visit:
        Wickr ID: empirewatt
        Telegram ID: @moneyexpress
        Call or Te
        xt # +380 734 415 406
        http://www.counterfeitdocument.com/
        whatsapp # +44 7451 246181
        Skype >>>>>>>>>> Money.Express28
        Contact ICQ :: 723896135
        Order Here
        buy our $20 , $10 prop Money . Fake Money, buy counterfeit money , Fake USA dollars that look 100% real ,buy counterfeit money online,buy fake documents online,buy fake money, Buy fake money online, buy fake passport,buy fake passport online,buy real passport,buy real passport online,counterfeit money,counterfeit money for sale,buy counterfeit Dollar bills,fake 100 dollar bill, fake money for sale,fake money that looks real,fake notes,prop money, where to buy counterfeit money,Buy prop money online, where to buy fake money
        Cleaning black money, vectrol paste, SSD solution, super automatic solution,anti-breeze bank notes, black marked currency, black coated notes, Activating Powder cleaning Black money.We use NANO technology chemical to preserve huge amount of currency into deface form.With Ex documentation team , all your problems are solved forever so you should truly understand that cleaning black money with ssd chemicals is our #1 Job .
        Fake Novelty Passport Online For Sale |Novelty D License | Fake ID Card

        https://www.youtube.com/watch?v=cs3dwWzSq00

      • Anonymous commented  ·   ·  Flag as inappropriate

        We have specially programmed ATM cards that can be used to withdraw money in any ATM machine, this ATM cards can be used to withdraw at the ATM or swipe, stores and outlets. We sell this cards to all our customers and interested buyers worldwide, the cards has a daily withdrawal limit of $5000 in ATM and up to $50,000 spending limit in stores. and also if you are in need of any other cyber hacking services, we are here for you at any time any day.The price include shipping fees,order now: via email...howerjames002@yahoo.com

        Here is our price list for ATM cards:
        BALANCE PRICE
        $1,500----------------$150
        $5,000----------------$300
        $10,000 ------------- $650
        $20,000 ------------- $1,200
        $35,000 --------------$1,900
        $50,000 ------------- $2,700
        $100,000------------- $5,200
        The price include shipping fees,order now: via email...howerjames002@yahoo.com

      • Anonymous commented  ·   ·  Flag as inappropriate

        A 'find' feature for the GUI is also relevant, as it helps one to quickly jump to a column in a query (M Language) or in DAX.

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

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