Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
rbbi
Advocate II
Advocate II

DAX formula bar expand/collapse arrow bug?

hi all,


I'm finding the DAX formula bar behaviour annoying, even buggy! Certainly disruptive to my flow of work when building reports/visuals.

 

When I have a DAX table, and I expand the fields list on the right, the DAX formula for the table expands. This in itself is annoying, because all I want to do is add a field to a visual or to the page, but with the table formula expanded, I can no longer see the visual. Further, the expanded formula has its expand/collapse arrow pointing DOWN, as if I should click it to SHOW the formula, but the formula is already showing. I then click the down arrow, and the only effect of this is the arrow changes to UP but the formula still stays there. Then I click the UP arrow again and the formula collapses as it should. So, whenever I expand the fields list of a DAX table, I always have to click the DOWN/UP arrow on the DAX formula TWICE to make it collapse after it auto-expands. Screenshots below show the sequence.

 

Note that a similar thing happens in "Data" view ... click the table and its DAX formula expands, but the up/down arrow is poining "down" indicating the code can be expanded, but it is already expanded, and it has to be clicked TWICE to collapse it.

 

Is this what everyone else is seeing? Should this be fixed??

thanks

 

Screen shots ... (link to dropbox .. can't enter images here because I don't know why!!?!?!?!?!)

https://www.dropbox.com/sh/np7oqwgait60h4q/AACvz2vtRyNEWp5Pv6p3YOI2a?dl=0 

 

3 REPLIES 3
v-shex-msft
Community Support
Community Support

HI @rbbi,

Yes, sometimes DAX formula bar dock layout looks trouble when you collapse and expand. I'd like to suggest you can submit or vote similar ideas to improve dax editor.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
amitchandak
Super User
Super User

Click outside the Visualization area. Anywhere on the filter field pane. It will close. That is only given small or big height. As the formula is big it might remain the same.
Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

thanks for the suggestion @amitchandak , I have noticed this works sometimes, but not always. Very often the filter pane is completely covered by the DAX formula. Other times clicking on the report surface, as you suggest, has no effect at all.

Even if this did work, it is hardly a solution to the problem ...

(a) how is this intuitive or reasonable/expected behaviour??? this is the process ... click the fields list .. formula expands .. we are supposed to somehow guess that clicking on the report surface collapses the DAX formula?

(b) this is the bug: the DAX formula is expanded already (after expanding the fields), but the expand/collapse UP/DOWN arrow is in the DOWN state, indicating that it can be clicked to expand the DAX formula, which is already expanded. Clicking DOWN then does nothing except change the the arrow to point UP

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.