Forum Discussion
Microsoft EmployeeShare your thoughts on visual calculations (preview)
Microsoft EmployeeHi, thanks for chiming in! This is expected behavior at the moment since when you switch out the field parameter value the selected measure actually disappears from the visual. There is no way to get the selected value of the field parameter unfortunately.
Thanks for the speedy response!
When you say "at the moment", this means it would eventually get solved? Is it on the roadmap?
- jeroenterheerdt
what I meant is that we are aware but haven't found a solution we like yet. It's on the roadmap, but I don't have a date to share.
GepaxAdvocate I
I found an alternative… Ideally, it would work natively with the field parameter, but this is what I managed to do.
I manually created a field parameter:
prm_M_Tipo_Combustivel =DATATABLE(
"Tipo",STRING,{{"Diesel"},{"Arla"}})After that, I created a measure that uses “Measure A” if “Diesel” is selected, or “Measure B” if “Arla” is selected.
I used this measure in the visual, created a moving average (visual calculation), and it adjusts according to the selected option.
- jeroenterheerdt
got it, yes that works, but it's a workaround. Ideally this should work more directly. Thanks for sharing!