Changing 1/0 to Yes/No for a slicer

[michaelu1]

I have many columns of data stored in 1/0 that I need to create slicers for.

I could replace the 1/0 to Yes/No, but, if I understand correctly, data is stored much better in PBI as an integer.

Is there an easy to swap the 1/0 for a Yes/No with adding data to the model?

[vicky_]

One easy way of doing this is to just create a new table, with TableName = {(1, "Yes"), (0, "No")}, create a relationship and use the new table in the slicer. I'm not sure there's a way to change the display value without at least creating a new column or table. 

[michaelu1]

So essentially I'll need to create a ton of little tables for each of my slicers..

Not the worst thing, but does clutter up the model.

[v-jianboli-msft]

Hi @michaelu1 ,

You can use Replace Values in Power Query:

Then change the data type:

Here is the M code:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUTJUitWJVnICsgzALGc4ywUiGwsA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ID = _t, Column1 = _t]),
    #"Replaced Value" = Table.ReplaceValue(Source,"1","True",Replacer.ReplaceText,{"Column1"}),
    #"Replaced Value1" = Table.ReplaceValue(#"Replaced Value","0","False",Replacer.ReplaceText,{"Column1"}),
    #"Changed Type" = Table.TransformColumnTypes(#"Replaced Value1",{{"Column1", type logical}})
in
    #"Changed Type"

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[michaelu1]

Hi @v-jianboli-msft 

My understanding is that storing data as integers takes up the least amount of space.

Once I'm changing the data to something else I can just switch it to Yes/No. My question was how can I keep it as 1/0 in the model and still have the slicer showing Yes/No.