Logarithmic scale on Dashboard

I am working on a dashboard for a client. I am trying to show value classifications with total numbers but the classifications are of different order of magnitude.

So, I would think a logarithmic scale is my best option.

BUT, the client is having trouble understanding the concept.

I was wondering if there is a way to be able to have the users be able to swap the scales from logarithmic to linear on a Dashboard level?

1 Like

Hi - Welcome to AWS QuickSight Community. Thanks for posting this question and it is a interesting question. I never tried logarithm scale but found the documentation on this.

Hope this will help you.

Tagging QuickSight experts also for their feedback.
@Max @Thomas @thomask @Karthik_Tharmarajan @Bhasi_Mehta @Tatyana_Yakushev @Kristin @Biswajit_1993 @David_Wong

Regards - San

1 Like

Hi Sanjeeb,

Not WisamHanna, Wesley_tk

This doesn’t help at all. I am asking at the dashboard level that the end user can switch the scale, not the analysis level.

Thanks anyway.

1 Like

Hi @wesley_tk - Apologies for pronouncing your name incorrectly. Can you please submit a ticket to AWS team to check your issue as well. To raise an issue, please follow the below link - Creating support cases and case management - AWS Support.

If you do not have permission to submit a case, request your aws admin team to help you on this. You can share your screen in those discussions and AWS team will analyze and provide you the guidance.

Hope this will help you.

Regards - San

Na, in that case I’ll go through our SA.

Thought someone in the community might have run up this before and had a clever solution.

1 Like

No problem @wesley_tk . If you are getting a solution, please post here so that it can be useful down the line :slight_smile:

Regards - San

1 Like

I think you may be able to do this using parameters. Create 2 different visuals - the first one using the standard scale and the second one using logarithmic scale. Then create a parameter and a control to ask your users to select the scale they want to use. Set the value of the parameter based on their selection.

In free-form layout, you can stack the 2 visuals. You can put the one using logarithmic scale at the back. You can then create a rule to hide the visual which is in the front based on your parameter.

image

I haven’t done this myself but I think it should work. You can give it a try.

2 Likes

I’ve done something similar to that in PowerBI. That should work exactly how I want. Thanks so much David.

2 Likes