Forum Discussion
Display image based on measure
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:
Anyone have any idea how, can i proceed with it?
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
My good friend Chris has a blog on using the UNICHAR function
3 Replies
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
My good friend Chris has a blog on using the UNICHAR function