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
filter dropdown
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.
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!
