Forum Discussion
Web URL Images
Dog,
I don't know how you have your data but to simulate you information I have done this:
Table Data: KPI, Budget, PY
Table Images: ID (Up, Down, Right), URL image
Column with Variation Budget - PY (based on your formula)
Column with Var chk (based on your formula) with lookupvalue format as Web URL
Then added the KPI + Var chk to the multi row card and the image as the change I wanted, if I change the information the images act accordingly.
To give further detail I would need more details on the information and to waht level you want to have it, because if the KPI's are based on YTD, MTD value the setup may have to suffer some changes.
Regards
Mfelix
Dog,
I'm not formating the variables I have added the last var chk as a column in the table and then format that result into URL Image.
MFelix
Sorry MFelix
perhaps I'm being a bit slow here.
on the visual is the output the new column you've created?
if so, how are you controlling the output to only show the image you want based upon the results of the measure, ideally I need this dynamic.
I do appreciate the help :)
Dog,
I don't know how you have your data but to simulate you information I have done this:
Table Data: KPI, Budget, PY
Table Images: ID (Up, Down, Right), URL image
Column with Variation Budget - PY (based on your formula)
Column with Var chk (based on your formula) with lookupvalue format as Web URL
Then added the KPI + Var chk to the multi row card and the image as the change I wanted, if I change the information the images act accordingly.
To give further detail I would need more details on the information and to waht level you want to have it, because if the KPI's are based on YTD, MTD value the setup may have to suffer some changes.
Regards
Mfelix