Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |