Dynamically hide/show columns in chart view (row series)

[rfernandez]

Hi, I have a table with the values of the evaluation of an employee. Depending on the area of the employee I want to hide some cols from the chart view where I see his progress over time (each row of the table has the result of the assessments).

The use case is: "Display the progress (score) of skills of the area of the employee"

In the example, every row corresponds to an employee that belongs to the DEV area, I want to hide the DESIGN (last two cols) from the chart (second image)

DES SKILL A and DES SKIL B should be hidden based on the user area. 

I've tried:

• Using the visibility prop of the table. Didn't work
• Creating a slice. Same result.
• Creating a virtual column and set it's formula like this: IF([Assessment].[Assignee].[Area]="Design", [DES_Skill_A], 0). Didn't work

 Is there any way to hide cols from the chart based on the values of the series?