Table / visualization

[FILIPKACZMAR]

Hello my friends, how are you? Hope everything is well 🙂

I am asking you for some help.

I have got table with some skills, 1 means yes, 0 means no. 

There are some inspecotrs which you can choose and see their skills 

But I want to show by visualization/table on my dashboard only skill marked as "1". I tried put some filter on it, but it doesnt work.

Can you help me? Thank you, have a nice day 🙂

[FILIPKACZMAR]

Ok, I am idiot and did wrong what you said. Sorry. I am marking you as solved. Thank you once more

[FILIPKACZMAR]

Hello, thank you for help and your time, but now it looks like this:

[SpartaBI]

@FILIPKACZMAR you can PM me with a link to zoom/teams and we can look together.

[SpartaBI · Accepted solution]

@FILIPKACZMAR I suggest you unpivot these columns first in Power Query so you will have the different skills as valus in a new union skill column and one column with all the 1 and 0. It will then work for you as expected. 

      

Showcase Report – Contoso By SpartaBI