Forum Discussion
Dynamic Image Display
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.
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)
Thanks for the quick reply.
Yes I've done that and can display the icons as images in tables or some other visualisations, but I want to be able to only show image associated with the lowest severity (and only the lowest), at a given Slicer level.
- Greg_Deckler
Community Champion
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.
This does the job. Nice thinking around the issue.
I was hoping not to use a Table to do the visualisation but it'll work.
Small Edit:
Am I right that
IsLowest = IF(SUM([Severity])=[Lowest],1,0)
Should read
IsLowest = IF(MIN([Severity])=[Lowest],1,0)
as I want to look for the Minimum value in [Severity] for my comparison?
Hi, I tried with chiclet slicer. The image still doesn't show.
There was a visual named Image Viewer. Now no longer available.
Any suggest of dynamic image display in Power BI?
Thank you!
You can use "HTMLViewer" custom visual (available on Power BI store) to do the same thing as "ImageViewer" visual. The only catch being, you'll have to create html <img> tag for the images to display.
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
