Forum Discussion
Pivot table multi-column table
Thankyou, Cookistador, for your response.
Hi Khomotjo,We appreciate your inquiry on the Microsoft Fabric Community Forum.
Please find attached the screenshot and the PBIX file, which may assist you in resolving the issue:
If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will help other community members who may have similar queries.
Should you have any further questions, please feel free to reach out to the Microsoft Fabric Community.
Thank you.
Hello Khomotjo
Do you want to apply that at the visual level (only on one table) or a whole page ?
To apply slicler on the visual or the page, click on the visual and in the filter tab, you just have to drag and drop the filed on which you need to apply a filter
If I drag and drop it at the visual level:
Then you just have to select Yes
If you do not see this filter panne, you have to click on view and click on Filters
Now if you want to exclude this value for all reports you will build and know you will never have to make an analysis for Pick = No, the best practice is to do it in power query and exclude this value from your dataset