Unpivot columns

Hi Anonymous,

You can refer to following steps to create a map visual and slicer to achieve your retirement.

1. Enter to query editor and do 'unpivot columns' on all product columns, then save changes to dateview.

Full query:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("lZLLbsIwEEV/xco6jPxI/Fi2sEECsaBdURauE4rVxInyQOLv6yQURBtoWUSyZnHu3JPZbAJIUmNznYVo7gwEYYBHPjIyoxIkxjH1z4kkwIiUwTbcBJTUDZqmrmmrI1ob6192Z83D/EiAoJyIjk8IB8kGPpuhZZpYozO01K7daeOTrPu4CvgJJCNzykEIjnlfAAPmJ/4STXWV2OKga9NmukKz9GBNWt9sQG40YAwEUYwNDYRvEA0JeZdg31O0yMwNI2NmmIJIxaobTZQEpc77FhCiVdXsi7Izg+Z5mWnX1Oi5ra1L6/oR7RGoGEdxH0J9yEXLq7NN+unTqrKodGMLd4fzS0YEhMSSDzIkYMwG7gtalftmr7PcmvuOR7EMuBQXxZT3VL4+H8liMX3AcYRB8NPNEf/HSI978qXzUrvjYDkp/E2b+o/VrtakIJWU4ntPr2IAv7UYU34+6X9eVo8UwBTDUY+kflfvdrv9Ag==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"Company Name" = _t, #"Cryogenic Equipment" = _t, #"Dental Care Equipment" = _t, #"Home Healthcare Equipment" = _t, #"Medical Equipment" = _t, #"Medical Testing, Analyzing, and Diagnostic Equipment" = _t, #"Therapeutic Devices" = _t, #"Veterinary Equipment" = _t, #"Medical Consumables" = _t, #"Medical Instruments" = _t, #"Optical Healthcare" = _t, Latitude = _t, Longitude = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Company Name", type text}, {"Cryogenic Equipment", Int64.Type}, {"Dental Care Equipment", Int64.Type}, {"Home Healthcare Equipment", Int64.Type}, {"Medical Equipment", Int64.Type}, {"Medical Testing, Analyzing, and Diagnostic Equipment", Int64.Type}, {"Therapeutic Devices", Int64.Type}, {"Veterinary Equipment", Int64.Type}, {"Medical Consumables", Int64.Type}, {"Medical Instruments", Int64.Type}, {"Optical Healthcare", Int64.Type}, {"Latitude", type number}, {"Longitude", type number}}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"Company Name", "Latitude", "Longitude"}, "Product", "Value")
in
    #"Unpivoted Columns"

2. Create map visual and drag columns to correspond fields, then create a slicer based on unpivoted product column.

Regards,
Xiaoxin Sheng