How can we improve Power BI?

Syntax highlighting for DAX evaluation contexts

Evaluation context and its transition is one of the hardest concepts in DAX and I would find it extremely helpful, if syntax highlighting would assist us here: Let the colour of the table name show whether the expression will be evaluated:
in a row context (so the table name represents the record/current row and a scalar value will be returned, Color: purple).
In a filter context (so the table name represents the (eventually filtered) table and a list of its column values is returned instead, Color: gold.
Ideally, it would also indicate if a filter is active or not (or can become active once the measure is used in a pivot table). So with an empty filter, there would be no syntax highlighting.

I've described this idea in my blogpost here: http://wp.me/p6lgsG-KI

81 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

    Imke Feldmann shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    2 comments

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

        This is one of the most frustrating parts of using Power BI, the lack of a proper editor & syntax highlighting. Nesting functions gets very ugly very fast without this feature.

      • Renaud commented  ·   ·  Flag as inappropriate

        I agree, remembering what each DAX function does, even after 1.5 year using power BI, is just not possible. Excel offers in-line help when typing a function, power BI should be able to do the same

      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.