SWITCH DAX Measure Percentage Measure Format Issue

[Anonymous]

Hi Experts

See the following measure - i need to format the [% Within 6 Weeks] measure inside the switch to show as percentage values in the table - as opposed to 1 and 0 (ref to "D")

DAX Measure

[v-jianboli-msft · Accepted solution]

Hi @Anonymous ,

Please try:

Result (Switch) =

IF (

    HASONEVALUE ( DimMetricTable[KPI] ),

    SWITCH (

        SELECTEDVALUE ( DimMetricTable[KPI] ),

        "A", [Under 6 Week],

        "B", [Over 6 Week],

        "C", [Total Wait List],

        "D", FORMAT ( [% Within 6 Weeks], "Percent" ),

        "E", [Maxium Wait (in weeks)],

        "F", [Activity_],

        "G", [With D Codes],

        "H", [Without D Codes],

        BLANK ()

    )

)

Output:

Note: After using FORMAT() , the type of this value will be converted to Text.

Best Regards,

Jianbo Li

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

[amitchandak]

@Anonymous , If you have created a measure slicer, I would advise to use filed parameters released in May 2022

https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd