topic Re: Dynamic Format Measures in DAX Commands and Tips

Dynamic Format Measures

JB_AT — Wed, 13 Mar 2024 14:00:18 GMT

Hi

I have a measure that I would like to format dynamically when a value in a slicer is chosen. The value in the slicer when chosen will divide the result of the measure by 1, 1000 or1000000. The measure Format is Dynamic and I have entered the dax below to format it, which doesn't work as expected.

SWITCH( SELECTEDVALUE ( NumberFormatCalc[Format] ), "Ones", FORMAT ( ROUND ( [Actuals Calc], 0 ), "0,0" ), "Thousands", FORMAT ( ROUND ( DIVIDE ( [Actuals Calc], 1000 ), 0 ), "0,0" ), "Millions", FORMAT ( ROUND ( DIVIDE ( [Actuals Calc], 1000000 ), 1 ), "0.0" ) )

Any ideas on what i can do here?

Thanks

Re: Dynamic Format Measures

some_bih — Wed, 13 Mar 2024 14:56:05 GMT

Hi JB_AT check link

Re: Dynamic Format Measures

Anonymous — Thu, 14 Mar 2024 02:28:33 GMT

Hi JB_AT

First of all, thanks to some_bih for your timely and effective response.

Here is my testing.

My sample:

slicer table:

data table:

I don't have your source data, so I don't know how [Actuals Calc] is obtained, so I created the following formula just to get a measure.

Actuals Calc1 = SUM('Table'[Actuals Calc])

Then I modified your formula.

measure = SWITCH( SELECTEDVALUE ( NumberFormatCalc[Format] ), "Ones", FORMAT(ROUND ( [Actuals Calc1], 1 ), "0.0"), "Thousands", FORMAT(ROUND ( DIVIDE ( [Actuals Calc1], 1000 ), 1 ), "0.0"), "Millions", FORMAT(ROUND ( DIVIDE ( [Actuals Calc1], 1000000 ), 1 ), "0.0") )

Result:

Is this the result you expect?

If I've misunderstood you, please provide detailed sample data and the results you are hoping for: How to provide sample data in the Power BI Forum - Microsoft Fabric Community . Or show it as a screenshot or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Dynamic Format Measures

JB_AT — Thu, 14 Mar 2024 05:38:07 GMT

Thank you some_bih

I actually came across this article this week and didn't read it. It is a big help!

Thanks

Re: Dynamic Format Measures

JB_AT — Thu, 14 Mar 2024 05:39:01 GMT

Thank you Anonymous

This helps a lot.