Dynamic Image by Value

[Anonymous]

Hey all,

I created Image dimension which contains Precentage between 0.1% to 100%, Precentage groups(0, 0-10,10-20...) and URL images:

How can I connect this dimenssion to Fact table which contains a calculation of Percentage that I want to show alongside this images?

If can't I connect the tables, how can I dynamicaly show the images by the values?

Example: 12% will show the 20% image, 92% will show the 100% image.

Thanks 🙂 

[v-lili6-msft · Accepted solution]

hi  @Anonymous 

It sounds like a Dynamic Segmentation problem, you need to add two column start and from for each image.

then refer to this blog to create a measure

https://www.daxpatterns.com/dynamic-segmentation/

If you still have the problem, please share your sample pbix file and your expected output

Regards,

Lin

[amitchandak]

@Anonymous , Try creating a measure like this a mark it has URL

measure = Switch(True(),
[Percent]>0 && [Percent] =<.10 ,"image1",
[Percent]>.10&& [Percent] =<.20 ,"image2",
"image3"
)

[lbendlin]

Create your own theme with custom icons.

https://powerbi.tips/2019/07/icons-upon-icons/