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

Question & Answer
, , ,
1

Reference question- How can I change legend names dynamically as per parameter control selection?

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.

2

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!

1 Like