Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
siddhant_malik
Contributor
Contributor

Using a Variable input for selecting multiple Dimensions

Hi Team,

 

I am trying to create a variable that will allow user to input the values based on the Specific Dimensions which are Year Months, and thereby wish to create a bar chart showcasing the percentage change for those selected year months put as variable.

My Data looks like this.

Please help

 

Labels (1)
1 Reply
ramchalla
Creator
Creator

@siddhant_malik you can specify the expression in the measure in the below format in the bar chart.

sum({<MonthYear = {$(=vMonthYear}>} Amount)

and while entering the MonthYear values in the input field, we need to ensure that we keep them enclosed in single quotes like 'Jan2020','Feb2020','Mar2020'....etc