Forum Discussion
Value format as per parameter
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
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] ))
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.