undefined

[DMT_corp]

Hi . I have pictures of cities . What code in M language help me in terms putting city's pictures right after it's name. I mean whenever i put name of city, picture of it shoult be cropped next to it  . How can i do that ?

[BA_Pete · Accepted solution]

Hi @DMT_corp ,

To essentially 'hardcode' this behaviour, you can just insert images into your report by going to the Insert tab > Image.

To do this dynamically, you will need to create a table in Power Query that has a column for image ID (that can be related to any other tables in the model), and a column that contains the full URL as text type to the image, something like this:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("lc5BCoMwEAXQuwTc1YyNCtoD1E1vICI2SWNo4gRNanv7xoLQTRddzMDnw8xrW6IQlZENOZDRe7ecAIIzOAi66ru2UuiB4qxgS25LwNFanBbwY7BXKKHMofnc6BPGmjj9BRXS5aGAZUXlnumPmrpJke6wE87BmC/FLBfKDQahp2F+0fgVhLQI2g5Kwk16PsLal0UBf7o58HoXm0iJroplxzyNq0xYvdFI170B", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [imageID = _t, URL = _t])
in
    Source

Once you apply this to your data model, select the URL column fom the fields list, go to the Column Tools tab > Data Category (dropdown) and select 'Image URL'.

You can now relate your [imageID] column to other tables in your model the same way you would for any other dimension table, and bring the URL column into tables to display the image, like this:

Pete