Value need to change dinamically in barchart

Hi Team

In my report i need to create one bar graph like
x axis should be in barnd
y axis should be in count of brand and value of brand

here i need to maintain one dropdown filter like
count
value

if user select count
in bar graph y axis should be in count
if user select value
in bar graph should show value bars only

how can i achieve like these scenarios

image

filter dropdown

image

Hi @vinodkumarb,

You can do this by using parameters. Take a look at this demo.
https://democentral.learnquicksight.online/#Dashboard-TipsAndTricks-Interactivity-Dynamic-Dimensions-and-Measures

You can click on “Show Analysis” to see how it was created.

For this first create a parameter with default value.
After that create a filter and then write calculated filed with ifelse like this:
ifelse ( $parameter = ‘By Number of units’, filed1 , Field2 )
Make sure to use exact string in calculated field and in filter.

1 Like

Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!