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
I am using it to replace a usual KPI, my client wants to see up and down arrows.
so there is no slicer I can use, the output will be determined based upon financial data YoY
I have a measure that currently performs.
BudgetVsPreviousYear:=
var FC_FY = [Budget FY]
var BD_FY = [Actual PFY]
var RetVal = FC_FY - BD_FY
I was then doing this using unicode
return IF(ROUND(RetVal, -3) > 0, "⯅", IF(ROUND(RetVal, -3) < 0, "⯆", "⯇⯈"))
but this didn't display correctly for all users.
but i want to
var Chk = IF(ROUND(RetVal, -3) > 0, "Up", IF(ROUND(RetVal, -3) < 0, "Down", "Right"))
return LOOKUPVALUE(ImageTable[ImageURL], ImageTable[Name], Chk)
//the image table stores the name (up, down or right) for each url.
Dog,
I have made the same variables as you and was abble to make the images coincide did you format the var Chk as an Image URL?
The first try that i did I only add the URL after changing the format it worked.
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