Forum Discussion
cheid_4838
Helper IV
Helper IVChanging format when using measures in a slicer
I have a visual where I have created a slicer to switch between different measures. Some of the measures our percentages, dollars, and just decimal. I tried changing the format, but it won't change...
hi cheid_4838
In the slicer tabe, add a column that indicates the format string. For example
Measure Name Format String Dollar Value $#,# Percentage 0.00% Volume #,# Now, select the measure that switches between different measures. Go to format under the measure contextual tab. Click Dynamic from the dropdown.
Enter SELECTEDVALUE('slicer'[format string]) in the formula bar.
danextian
Super User
Super Userhi cheid_4838
In the slicer tabe, add a column that indicates the format string. For example
| Measure Name | Format String |
| Dollar Value | $#,# |
| Percentage | 0.00% |
| Volume | #,# |
Now, select the measure that switches between different measures. Go to format under the measure contextual tab. Click Dynamic from the dropdown.
Enter SELECTEDVALUE('slicer'[format string]) in the formula bar.