⚡⚡⚡More information in the description below⚡⚡⚡
A first look at Visual Level Calculations in the February 2024 release of Power BI Desktop. Looks very promising, should simplify a lot of common DAX requirements.

Formatting:
At this stage it's necessary to wrap in FORMAT which takes this pattern Positives ; Negatives ; Zeros
FORMAT( [Measure], "#,#0.0; (#,#0.0); - " )

For more format options see https://learn.microsoft.com/en-au/pow...

If you need to do further calculations on a field AND you want to display it formatted then you will need to create a duplicate unformatted column and hide the original non formatted column that is used in further calculations.

At this stage you also cannot sort by a measure value (the RUNNINGSUM doesn't respect the sort order of a visual if it's sorted by a measure) Instead you'd need to do something like this
RUNNING TOTAL by Units= SUMX(WINDOW(1, ABS, 0, REL, ROWS, ORDERBY([Units], ASC)), [Units])

The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/

Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/


Connect with me
https://wyn.bio.link/