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
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
Super User
Super User
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.