Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@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