Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have such data
I want it to be like this in power bi so that i can use flow map and use count as width
how can i do it help me
Solved! Go to Solution.
Hi @SunnyRKFOODLAND ,
Use group by feature in Power Query Editor:
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WKk4t0DUyUtJRyi7NS8nJBDJK8/IS85VidUaiXGJGbmpKYlJiyqg8Vvns/JzsxJJEymRjAQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Month = _t, #"veh location" = _t, #"income location" = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Month", type date}, {"veh location", type text}, {"income location", type text}}),
#"Grouped Rows" = Table.Group(#"Changed Type", {"Month", "veh location", "income location"}, {{"Count", each Table.RowCount(_), Int64.Type}})
in
#"Grouped Rows"
Best Regards,
Jay
Hi @SunnyRKFOODLAND ,
Use group by feature in Power Query Editor:
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WKk4t0DUyUtJRyi7NS8nJBDJK8/IS85VidUaiXGJGbmpKYlJiyqg8Vvns/JzsxJJEymRjAQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Month = _t, #"veh location" = _t, #"income location" = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Month", type date}, {"veh location", type text}, {"income location", type text}}),
#"Grouped Rows" = Table.Group(#"Changed Type", {"Month", "veh location", "income location"}, {{"Count", each Table.RowCount(_), Int64.Type}})
in
#"Grouped Rows"
Best Regards,
Jay
yes. but I want to use that as a table in the flow map ( Visual Addin) to show A to B traveeling frequency. using matrix can i do that?
YourMeasure = COUNT('Table'[Income Location])