Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created a chart and wanted to hide a dimension/bar from that chart, how can I update that?
Country Value
A 2000
B 3000
C 4000
D 5000
I do not want to show value C in my bar chart.
I would prefer doing this using the set analysis as it offers better performance
Dimension:
Country
Expression:
Sum({<Country -= {'C'}>}Value)
In the dimension write (Edit dimension)
if(Country='C', Null(), Country)
then check the box "Exclude null values"
Let me know
In addition to Alessandro'point, we can write below script to hide multiple values in a dimension.
IF(not Match(Country,'A','C'),Country)
I would prefer doing this using the set analysis as it offers better performance
Dimension:
Country
Expression:
Sum({<Country -= {'C'}>}Value)
May be like this,
Updated : This is Similar to @Sunny T
Please go to Ctrl+E --> 217364
And PFA.