Display image based on measure

[Anonymous]

Hi all,

Im struggling to find a way to dispaly images based on my measure.

I have a measure  called TO - Average that changes based on the filter/slicers, and i'd like to dislay an image based in the measure results: 

•  0% to 1.5%
•  1.6% to 3%
•  3.1% to above

Anyone have any idea how, can i proceed with it? 

[Phil_Seamark · Accepted solution]

Hi @Anonymous

This is much easier with calculated columns when you can mark the column in the Web URL data category, but these won't respect filters/slicers.

You can use the UNICHAR function in measures to get a simlar effect and there are a tonne of useful unichar values you can draw on.

eg, the following will give you a thumbs up, you can wrap this in an IF or SWITCH statement to generate the UNICHAR code you need.

Measure = UNICHAR(128077)

There are a bunch of websites that list the kinds of codes you can use, but here is one

https://www.fileformat.info/info/unicode/block/miscellaneous_symbols_and_pictographs/list.htm

[Phil_Seamark · Accepted solution]

Hi @Anonymous

This is much easier with calculated columns when you can mark the column in the Web URL data category, but these won't respect filters/slicers.

You can use the UNICHAR function in measures to get a simlar effect and there are a tonne of useful unichar values you can draw on.

eg, the following will give you a thumbs up, you can wrap this in an IF or SWITCH statement to generate the UNICHAR code you need.

Measure = UNICHAR(128077)

There are a bunch of websites that list the kinds of codes you can use, but here is one

https://www.fileformat.info/info/unicode/block/miscellaneous_symbols_and_pictographs/list.htm

[Phil_Seamark · Accepted solution]

My good friend Chris has a blog on using the UNICHAR function

https://blog.crossjoin.co.uk/2017/04/11/the-dax-unichar-function-and-how-to-use-it-in-measures-for-d...

[Anonymous]

Thanks a lot @Phil_Seamark ! 

It worked perfectly !