Forum Discussion
Data masking boolean for filters
Hello community,
Is it possible to mask boolean values in a slicer visualization?
Instead of seeing "Select all", "0", "1" I would like to see "Select all", "No", "Yes".
Data is being handled through DirectQuery from a database...I have the flexibility to modify the SQL query and add some logic such as "IIF(condition_is_true,'Yes','No)" but maybe its better to treat it as bit instead of char and do the appropiate handle in PowerBI Desktop report/dashboard?
Cheers,
there might be many ways to do that, one you said and the other is that you can create a calculated column based on "if" function and then used that column in your slicer. or one other way is to usegroup by option in power bi desktop by clicking on your column.
If this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.
1 Reply
- Selva-Salimi
Solution Sage
there might be many ways to do that, one you said and the other is that you can create a calculated column based on "if" function and then used that column in your slicer. or one other way is to usegroup by option in power bi desktop by clicking on your column.
If this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.