Forum Discussion
Table / visualization
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 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.
4 Replies
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.
Hello, thank you for help and your time, but now it looks like this:
FILIPKACZMAR you can PM me with a link to zoom/teams and we can look together.
Ok, I am idiot and did wrong what you said. Sorry. I am marking you as solved. Thank you once more
