# How to add % sign for dynamically changing metrics based on parameter?

**URL:** <https://community.amazonquick.com/t/how-to-add-sign-for-dynamically-changing-metrics-based-on-parameter/38539>\
**Category:** Q&A\
**Tags:** analysis, calculations, Business-Intelligence-Engineer, quick-sight\
**Created:** [November 18, 2024, 4:36pm UTC](https://community.amazonquick.com/t/how-to-add-sign-for-dynamically-changing-metrics-based-on-parameter/38539 "2024-11-18T16:36:32Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rishita\_Chebrolu](https://avatars.discourse-cdn.com/v4/letter/r/c4cdca/32.png) [@Rishita\_Chebrolu](https://community.amazonquick.com/u/Rishita_Chebrolu)\
**Post date:** [November 18, 2024, 4:36pm UTC](https://community.amazonquick.com/t/how-to-add-sign-for-dynamically-changing-metrics-based-on-parameter/38539/1 "2024-11-18T16:36:33Z")

</div>

Reference question- [How can I change legend names dynamically as per parameter control selection?](https://community.amazonquick.com/t/how-can-i-change-legend-names-dynamically-as-per-parameter-control-selection/36677)

With reference to the above chart, I have calculations in metric1,Metric2 which are a mix of numbers and percentages. I would like to display a % sign when a percentage metric is selected in the dropdown. How do I implement that?

I understand I can select the data type for overall metric1 and not individually? Is there any workaround?

I also tried directly using a calculated fields inside the metric1 but it shows me an aggregation error so I had to put the calculations inside metric1 only.

---

<div class="post-metadata">

**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\
**Post date:** [November 18, 2024, 10:48pm UTC](https://community.amazonquick.com/t/how-to-add-sign-for-dynamically-changing-metrics-based-on-parameter/38539/2 "2024-11-18T22:48:38Z")

</div>

Hi @Rishita_Chebrolu,  
There is no way to utilize different types of metrics on the same visual.

The best work around for this case would be to utilize a free form layout; create a visual that utilizes percentages and one that utilizes numbers.  
Under the ‘rules’ section, set each visual to ‘hide this visual by default’. Then create a rule for each one to ‘show visual’ based on what your parameter is set as on the dropdown.

Let me know if you have any additional questions!

---

<div class="post-metadata">

**Author:** ![Rishita\_Chebrolu](https://avatars.discourse-cdn.com/v4/letter/r/c4cdca/32.png) [@Rishita\_Chebrolu](https://community.amazonquick.com/u/Rishita_Chebrolu)\
**Post date:** [November 22, 2024, 7:37pm UTC](https://community.amazonquick.com/t/how-to-add-sign-for-dynamically-changing-metrics-based-on-parameter/38539/3 "2024-11-22T19:37:35Z")

</div>

But this would only when both the selected metrics in bar and line are %. If one is a % and the other is a number it would show number also as %.

---

<div class="post-metadata">

**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\
**Post date:** [November 27, 2024, 5:49pm UTC](https://community.amazonquick.com/t/how-to-add-sign-for-dynamically-changing-metrics-based-on-parameter/38539/4 "2024-11-27T17:49:58Z")

</div>

Hi @Rishita_Chebrolu,  
I’m not quite sure what you mean, could you please elaborate? As mentioned above, there are current limitations that don’t allow visuals to show numbers and percentages at the same time.

---

<div class="post-metadata">

**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\
**Post date:** [December 9, 2024, 8:36pm UTC](https://community.amazonquick.com/t/how-to-add-sign-for-dynamically-changing-metrics-based-on-parameter/38539/5 "2024-12-09T20:36:28Z")

</div>

Hi @Rishita_Chebrolu,  
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

---

<div class="post-metadata">

**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\
**Post date:** [December 12, 2024, 7:48pm UTC](https://community.amazonquick.com/t/how-to-add-sign-for-dynamically-changing-metrics-based-on-parameter/38539/6 "2024-12-12T19:48:26Z")

</div>

Hi @Rishita_Chebrolu,  
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!

---

<div class="post-metadata">

**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\
**Post date:** [December 12, 2024, 7:48pm UTC](https://community.amazonquick.com/t/how-to-add-sign-for-dynamically-changing-metrics-based-on-parameter/38539/7 "2024-12-12T19:48:29Z")

</div>


