Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to create a filter which applies only to a particular Bar chart but not to other charts
@Akash2k Try below
1) Add filter to alternate state.
2) Create measure in bar chart with alternate state intersection with other filter as below
This way your filter will only work for bar chart as filter is in alternate state and it is referred only in bar chart measure, so other visualisation will not be affected. Also bar chart will take other selections in account as defined in bar chart measure
Sum({[Compare 1]*$}Value) -- where [Compare 1] is defined alternate state
try using Alternate State option
If I create and use that alternate state, the filter only works on the bar chart( other filters are not working on this bar chart).
However, I expect this filter to work specifically on the bar chart, while also allowing other filters to apply to it as well
thanks for your help
Apply the alternates states to the filter and not the bar chart.
In the bar chart expression, Try writing an if statement, whn getselectedcount(Altstates_yourfilter) > 0, then Measure1 else Measure2. Measure1 has the expression with alternatestates included. if that doesnt work, check on how to write an expression to include current selections and alternate states.
@Akash2k Try below
1) Add filter to alternate state.
2) Create measure in bar chart with alternate state intersection with other filter as below
This way your filter will only work for bar chart as filter is in alternate state and it is referred only in bar chart measure, so other visualisation will not be affected. Also bar chart will take other selections in account as defined in bar chart measure
Sum({[Compare 1]*$}Value) -- where [Compare 1] is defined alternate state
Great that works ,
Thank you so much kushal ,Qrishna, anat
How can i apply the same in a table chart
where there is no measure column