Forum Discussion
Using local images in matrix column -- String Larger than Page Size
Update: I tried the function on other pictures and it seemed to work as expected. I noticed that the .jpegs that it worked with were much smaller than the pictures that it didn't work with, so I got the pictures under about 20 kb each and it's now working perfectly! I guess the length of the URL string is directly correlated with how big the file is.
hi, christinamarie
When you try to order the pictures alphabetically by name, if you could try to use the Sort by Column button
Add a rank column for this picture column, then sort by column not sort it directly.
Best Regards,
Lin
v-lili6-msft Sorry, to be clear, I was using the Sort by Column. Each picture has a name "Tommy.jpeg", "Lisa.jpeg", and also has the local URL column called BinarytoPbiImage, which I've placed in the "Column" field of the matrix visual. Whenever I try ordering BinarytoPbiImage by name, I get the error. I attempted what you said and tried using an Index column (numbered it in alphabetical order starting from one) but I ended up getting the same error. :(
Update: I tried the function on other pictures and it seemed to work as expected. I noticed that the .jpegs that it worked with were much smaller than the pictures that it didn't work with, so I got the pictures under about 20 kb each and it's now working perfectly! I guess the length of the URL string is directly correlated with how big the file is.