Forum Discussion
undefined
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 ?
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 SourceOnce 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
1 Reply
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 SourceOnce 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