Asking for a friend…this seemed like a really good question, looking for an expert answer. How do I let my dashboard viewers switch selected fields in a chart?
1 Like
This can be done using parameters.
-
Create a parameter and use it to create a control with a list of predefined values.
-
Set one of those predefined values as the default for your parameter.
-
Then create a calculated field like this. This is basically saying that depending on the value which is selected in the control, the calculated field should be equal to another field in your dataset. For example, if the user selects “Business Unit” in the control, the calculated field takes the value of the “Business Unit” field.
- Finally add the calculated field as a column in your table. Put the parameter in your column header so that it reflects the user’s selection.
2 Likes
Hi @Jill_Florant, I guess @David_Wong solution worked for your friend. Let us know if this is resolved. And if it is, please help the community by marking his answer as a “Solution.”
Regards,
Karthik
2 Likes
@David_Wong and @Karthik_Tharmarajan thanks for all of your help on this. Got one more resource from our internal team that helps too. Thanks Andrei!
3 Likes