Deselect in bar chart

[yoganantha321]

I have used the following expression and one field as dimension in bar chart.

Dimension:   

Field 1: =IF( MonthlyWorkHour>7, 'Occupied',  IF(  MonthlyWorkHour>3 and MonthlyWorkHour<8, 'Partially Occupied',  IF( MonthlyWorkHour<4,  'Available' )))

Field 2: Project Name

Expression: count (Employee Id)

I got the output as

When I selected partially occupied, the single bar highlights and again selected it bring backs to the original position like below

         

but while selecting on the other two namely Occupied and Available I cannot get back to the original status as shown in first image

Regards,

Yoganantha Prakash G P

[Anonymous · Accepted solution]

hi,

Better you can use this expression  as a field of table and place it in any dimensional or fact table  IF( MonthlyWorkHour>7, 'Occupied',  IF(  MonthlyWorkHour>3 and MonthlyWorkHour<8, 'Partially Occupied',  IF( MonthlyWorkHour<4,  'Available' )))  then it will change according what you select