You might need to make your Calculated field a string and add conditional formatting logic to it.
The workbook I attached in the solution to the following thread has an example of string manipulation to mimic formatting.
Yours will need to be based off of your parameter selector but the principle is the same.
Hi Aaron, Thanks a lot! I was able to include a $ or % sign using a CALC for formatting before the total CALC, but can’t figure out how to change the decimal places --- none for dollars or volume, 2 (so $x.xx) for price, and 1 (so x.x%) for percentages. Any suggestions here?? I attached a packaged workbook for reference. I’m really racking my head w/ this-
Number Formatting Workbook.twbx 59.2 KB
After looking at your workbook I have a better suggestion I think.
Format all of your measures as you need them to be under their Default Properties>Number Format.
Then set your viz up like I have below. Places only measure values on label. Right click on the measure values label and click "Show Quick Filter." Then adjust the filter to be a single value drop down.
Delete or hide any measures that you don't want on this filter.
Let me know if this is a usable solution.
Thanks for your help w/ this Aaron! I think this works here-
No Problem Paul. Make sure that if your post is answered that you set to "Answered."