Hello. I am creating a dashboard and have a dynamic filter using a parameter that changes the y-axis from a currency to a percent. However, I have not found a way to change the formatting of the y-axis to change with this (it is currently just a number). Is there any way to do this? I have tried almost everything so unsure where to go from here.
Hi @paj324 and welcome to the QuickSight community,
Even when creating a calculated field to try and handle this, your ifelse would need to include a number of functions that can help create strings so that you could include a percentage symbol. If the calculated field turns out to be a number or integer field, you will be prompted to select the format to show the field value as.
The best work around for this that I would suggest; would be to instead create duplicate visuals, one that is setup in currency and one that’s setup in percents. Create rules to hide the visuals and then use the parameter to show the correct visual that corresponds with it. You’ll need to use the free-form layout, but with this, you can layer one map on top of the other (make sure to hide the background of the visual) and it will give the affect of switching the visual when you change the parameter.
Let me know if you have any additional quesitons
1 Like
That is a great work around thank you.
Ok I tried doing so, but when I hide the visual it doesn’t disappear. It only says “Hidden based on a rule” and it covers up the graph behind it.
Hi @paj324,
Make sure to hide the background on both visuals so that message does not show:
Hi @paj324,
Following up here as it’s been awhile since we last heard from you; did you have any additional questions regarding your post?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you!
Hi @paj324,
Since we have not 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.
Thank you!