Forum Discussion

Dog's avatar
Dog
Responsive Resident
9 years ago
Solved

Web URL Images

Hi All,   I have an issue currently were I need to display an image in a card visual based upon the movement of financial data.  in summary an up or down arrow if the value is higher or lower than...
Need Help
  • MFelix's avatar
    MFelix
    9 years ago

    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

MFelix's avatar
MFelix
Super User
9 years ago

Hi Dog,

 

I have a dashboard that uses URL images and made use of the custom visual "Image Viewer" this allows me to interact with the slicers or graphs in a dinamic way, I don't know how you have the summary set up but you can have the image associated with the interaction of the slicers/graphs and have the image changing.

 

 

Regards,

 

MFelix

 

 

  • Dog's avatar
    Dog
    Responsive Resident
    9 years ago

    Thanks alot MFelix

     

    I forgot to mention that I cannot use custom visuals either :( as my client needs to export to Power Point. 

    That said I hadn't realised that this visual existed so I will use that in the future. 

     

    I will mark yours as the solution if no one else comes up with any other potential options... although I am rapidly believing that this isn't going to be possible any other way 

     

    Cheers

  • MFelix's avatar
    MFelix
    Super User
    9 years ago

    Hi Dog,

     

    I just change my PBI to the multi row card and it also works fine, how do you want to set up the filter to the card? A slicer? A graph? how do you know what is the image you want to display.

     

     

    MFelix

    • Dog's avatar
      Dog
      Responsive Resident
      9 years ago

      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.

       

       

       

      • MFelix's avatar
        MFelix
        Super User
        9 years ago

        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