topic Re: Hide Values in matrix in DAX Commands and Tips

Hide Values in matrix

Rinkin_Vaghani — Sat, 20 Feb 2021 15:37:34 GMT

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?

Re: Hide Values in matrix

Carmichael — Sat, 20 Feb 2021 16:26:54 GMT

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!!

Re: Hide Values in matrix

daxer-almighty — Sat, 20 Feb 2021 18:17:35 GMT

Use the Filter Pane with a suitable condition.

Re: Hide Values in matrix

Rinkin_Vaghani — Sun, 21 Feb 2021 04:01:43 GMT

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.