I have a question about the upcoming Expression-Based Formatting feature. The description reads as follows:
"Report authors need flexibility over how their visuals are formatted. As well as defining formatting through the formatting pane, a DAX expression can be used to set the formatting, giving full control over the business logic used to format the visual.
Authors can create rules that set the color of a KPI based on the progress towards a goal, set the style of a line on a chart based on which category is performing best, or any combination of these. Authors can even dynamically update the title of a visual based on selections made elsewhere in the report."
Do you all think this means I would be able to do a switch function, and designate the format (i.e. show as currency) in a visual with that switch function as a field? So, if the measure containing the switch function has a general number format assigned, but within the switch function I say that one of the switch possibilities should be shown as currency, that when that option is selected it will show up in the visual as currency? Or no matter what the visual will still only show the format that is selected as attached to the switch function measure? I'm sorry if I'm not being very clear with this! Let me know if I should explain it differently, thank you!!!!
Thanks for your reply. However using the Format function converts it to text, correct? Unfortunately this doesn't work for me since I would need to use this for a variety of visuals (column charts, line charts), not just matrixes and cards. And in that case, I believe Format just wouldn't work.
I did however just find a proposed idea that seems to cover exactly what I'm looking for: