Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
@rssilvaba , Oneway is to unpivot the table
https://radacad.com/pivot-and-unpivot-with-power-bi
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |