Forum Discussion

dvotf's avatar
dvotf
Frequent Visitor
9 years ago
Solved

Dynamic Image Display

Hi guys,   I'm trying to find a way to dynamically display an image based on the values selected in a Slicer. For example, I might have a dataset that could be {Good, Medium, Bad} and I want to dis...
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    You could probably do something along the lines of create a measure like:

     

    Lowest = CALCULATE(MIN([Severity]),ALLEXCEPT(Table,Table[Category]))

     

    Then create another measure like:

     

    IsLowest = IF(SUM([Severity])=[Lowest],1,0)

     

    Then drop your IsLowest as a filter on your table visualization of the error code images.

     

    The idea here is that Lowest calculates to the MIN taking into account the Category. The IsLowest will be filtered by the row context of the table so only the lowest will be 1.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

dvotf Click on the column that has the image url. In the Header ribbon in the Properties section -> Select "Data Category" - > "Image URL" (second from the bottom)

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hello,

 

That is not valid for calculated measures, why? It's mandatory.

 

I am looking for an image based on a sum of values, and the result in the table is the URL (the one I put in a conditional for the calc. measure) as a text, not as an image.

 

Regards