Forum Discussion
Value format as per parameter
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.
Hi Anonymous
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
3 Replies
Hi Anonymous
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
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.