Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
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.
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.
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.
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.
User | Count |
---|---|
123 | |
70 | |
67 | |
58 | |
53 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
52 |