Use parameters to show/hide fields in a chart

Q&A
, ,
1

Is it possible to show/hide specific fields on a chart based on parameters?

I have 6 calculated fields:
Milestone_A_1
Milestone_A_2
Milestone_A_3
Milestone_B_1
Milestone_B_2
Milestone_B_3

I want to have all 6 fields as default on my vertical bar chart (or any other similar chart) and when I filter by parameter A or B, the chart will show only the fields related to the specific parameter. If I’m selecting A as parameter, I only want to see: Milestone_A_1, Milestone_A_2, and Milestone_A_3, and hide fields for parameter B.

Not sure if possible, any guidance would be highly appreciated.

Thanks!
Cris

2

Hi, @crizar,

Yes you can do this using parameters and a control .

  1. Build a static text parameter (e.g. pMilestone)
  2. Create a control on top of this parameter with 6 values - Milestone_A_1 thru 3 and Milestone_B_1 thru 3. Users will make the selection on what they want the chart to show using this control.
  3. Create a calculated field: if the parameter value is Milestone_ then use the Milestone_ field, elseif use the next field and so on.
  4. Place this field in the Color/Group/Dimension field well of your chart.

Did this answer your question? If so, please help the community out by marking this answer as “Solution!”

1 Like
3

Hi @crizar,
It’s been awhile since we last heard from you; did Xclipse’s solution work for the issue you were encountering or do you have any additional questions?

If we do not hear back within 3 business days, I’ll mark as solution but if you have any additional questions, feel free to create a new topic for discussion.

Thank you!

4

Hi @crizar, I am marking this reply as, “Solution,” in case you need further assistance with your problem, please create a sample dashboard with sample dataset showing your problem state using Arena and please create a new post, so we can look at it from a fresh perspective. (Details on using Arena can be found here - QuickSight Arena)