Value format as per parameter

[jeongkim]

Hi,

How can I dynamically change its format as per specific column? 

e.g.

If 'Unit' = [%] then decimal 2 such 99.99

If 'Unit' <> [%] then whole number such 99999

please help create measure. 

[danextian · Accepted solution]

Hi @jeongkim 

Add a column that indicates the format string for each each row. Select the measure, go to Format and select Dynamic

The first row's format string would be 0.00%, while the second row would use the format #,0.00.

Note: You may need to divide your percentage values by 100. Otherwise, they could appear incorrectly — for example, 0000% or 9986% instead of the expected percentages.

Please refer to this blob - Create dynamic format strings for measures 

[jeongkim]

value is calcuated by measure  not from column values.

how can I add your method? 

KPI Value =

    switch (

        true() ,

        selectedvalue('PM Data - Append Report_Data'[unit]) = "[%]" , average ( 'PM Data - Append Report_Data'[Value] ) ,

        sum ( 'PM Data - Append Report_Data'[Value] )

)

[danextian]

This is still a column and you're trying to return different measures depending on the current row value. You either add a format string column to that table or create format strings purely in a DAX expression. 

IF (
    SELECTEDVALUE ( 'PM Data - Append Report_Data'[unit] ) = "[%]",
    "0.00%",
    "#,0"
)

Please go to the link in my initial reply.