Forum Discussion
Hide Values in matrix
Below is screenshot of power BI visulal, i am currently working with. I have issues with "present Days". I want to check that how many welders are available for less than 7 days & between 7-15 Days (different color for both condition). However, I dont want welders having more than 15 days presence. Is there any way to hide those welders having present day more than 15 Days? Or suggest if any third party visual available for this?
3 Replies
- Carmichael
Advocate III
Look to set this in the filters pane for either the visual, page or report level.
put the present day value into the filters well and then change drop down to advanced and set accordingly
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-report-add-filter
Did I answer your question? Mark my post as a solution if I did! Like it if it helped. Appreciate the Kudos!!
- Rinkin_VaghaniFrequent Visitor
Thanks for reply. But this won't help. Column "present Days" is count (distinct column). Hence, i can not put any filter in filter Pan.
- daxer-almighty
Solution Sage
Use the Filter Pane with a suitable condition.