I’m looking to complete a fairly simple transformation in a country table from this dataset.
I wanted to confirm what Power BI users thought a good recommended approach for this scenario would be?
I want to show a SINGLE country on the ROW with an index (from 1) and the PIC on the column and repeated as a column if required. ie Pic1, Pic2, Pic3, Pic4 etc. Here is the current position of the data.
I hoping to make this a dynamic country dimension table with Base64 picture encoding per Chris Webb’s Binary to Image post.
Per Chris’s blog some image names (country names) can be repeated if the image size is larger then the limitations. You can see Europe for example is repeated 4 times so it would need 4 columns to hold each of the repeated rows with the PIC data transposed to each new column. In contrast a smaller picture size only need a single row.
What is the best M code to use to complete this transformation in the Query Editor?