How can I create a slicer that filters specific columns

[rssilvaba]

Hi All,

I have a table view with something like the following.

Name (any other column)	Finance	IT	IS	Other
-	0	0	0	0

Where the left side can be any related column and the others on the right are actually departments.
Since the table is this way I wonder how I can create a Department slicer so it filter the items that are > 0 for the matching columns.

I have no idea how I can approach this. Any input will be very appreciatated.

Thanks.

[v-henryk-mstf]

Hi @rssilvaba ,

Do all the fields come from the same table? In the case that the table visual is created correctly, you can put the "item" field in the Filter, and then filter the results with a value> o.

If the problem is still not solved, can you provide more detailed information and test data? So that I can solve your problem as soon as possible.

Let me know immediately, looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@rssilvaba , Oneway is to unpivot the table

https://radacad.com/pivot-and-unpivot-with-power-bi