Forum Discussion
Microsoft EmployeeShare your thoughts on visual calculations (preview)
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.
Advocate IThank 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.
- jeroenterheerdt
thank you, appreciate the extra input.
- kleigh
Perhaps not with the normal settings, but having it look similar to editing other things like measures - so a "visual calculation" tab appears in the ribbon when editing. This can change the "Data format" option if that's what works. It could also have the "show in visual" switch (and anything else useful, but nothing comes to mind immediately).
- jeroenterheerdt
thank you, this is really helpful input!
