Replace False / True in slicer created with BIT column with Yes/No

[NeimadB]

Hello,

I've built a report with a Sales fact table, which have several flag (BIT type in SQL Server) columns in my model, for exemple Local, Bio etc....

When I create slicers with these columns, as shown below, it displays True / False on all my columns slicers, and instead of it I would like to see Yes / No.

Is there a way to customise this ?

Or at leat, to translate these labels (as my report is not in English).

Thank you

[lbendlin · Accepted solution]

Add calculated columns that "translate" the 0/1 values into what you want to display. Then use the new columns for your slicers.

[NeimadB]

This is what I've done for all my BIT columns.

Thank you