Forum Discussion
Post ProdigyRemoving decimals from values while keeping for totals
Unfortunately, with live connection, you will need to apply the dynamic format string to the measure in the semantic model itself. Alternatively, you can create another measure that returns a formatted text instead
IF ( NOT ( HASONEVALUE ( Geo[Geo] ) ), FORMAT ( [my measure], "#,#.00" ), FORMAT ( [my measure], "#,#" ) )
Post Prodigydanextian I tried your solution as well, but same problem it requires column while I can only provide measure.
Super UserApply dynamic format string to a measure but reference the column in your formula. You are referencing the measure the string is to be applied to and not to the dates.
- Justas4478
danextian I quickly looked in to and it seasm I cant create dinamic format since it is on for model measures and not ones using live connection.
- danextian
Unfortunately, with live connection, you will need to apply the dynamic format string to the measure in the semantic model itself. Alternatively, you can create another measure that returns a formatted text instead
IF ( NOT ( HASONEVALUE ( Geo[Geo] ) ), FORMAT ( [my measure], "#,#.00" ), FORMAT ( [my measure], "#,#" ) )- Justas4478
danextian It works thanks for the solution.
To bad that it doubles refresh time.But I guess this is only option I have.