Forum Discussion
Microsoft EmployeeShare your thoughts on visual calculations (preview)
Advocate IWhen creating a visual calculation with an expected result in %, it would be nice to be able to set the format in % without using the FORMAT DAX function, so we can be able to use it in a graph and show the value on the axis as %.
Also a nice feature would be to be able to use the visual calculation in the conditionnal formatting.
For example I'd like to use it to create pareto chart and customize the stack color based on the % value.
Responsive ResidentYou can now set the format on visual calculations without the FORMAT function, but it's not obvious at the moment.
It's in the General tab > Data Format. Definiely something that should be available as you're editing. It's also not sticky, so if you change your calculation it might revert to a default format.
- julie_duquesne
Thank you, I found it with. It's really not obvious.
- jeroenterheerdt
the stickyness is an issue which we are aware of. Since visual calculations are not in the model, they cannot be formatted using the normal formatting settings. Where would you have wanted to find these formatting settings?
- julie_duquesne
Instead of format > General, maybe in Format > Visual, under a specific category "Visual Calculations" would make sense. I kind of never use the General tab in Format so I didn't think of it when looking for a way to format it.
