Forum Discussion
Display an Image if not filtered
Hi Guys,
I'm trying to display a default image if the filter is not selecting anything. The problem is qhen there is no filter applied and comes the "first link" eg.:
TABLE
NOT FILTERED
FILTERED
Hi Anonymous
I would recommend creating a measure such as this:
Selected Link = SELECTEDVALUE ( YourTable[Link], <expression resturning default link> )
This will return a default link in the case of multiple Link values, otherwise the selected link image in the case of a single Link value.
Ensure that the Data Category for this measure is set to Image URL (Modeling => Data Category) and then place this measure in the table or other visual that supports Image URLs.
Regards,
Owen
3 Replies
- OwenAuger
Super User
Hi Anonymous
I would recommend creating a measure such as this:
Selected Link = SELECTEDVALUE ( YourTable[Link], <expression resturning default link> )
This will return a default link in the case of multiple Link values, otherwise the selected link image in the case of a single Link value.
Ensure that the Data Category for this measure is set to Image URL (Modeling => Data Category) and then place this measure in the table or other visual that supports Image URLs.
Regards,
Owen
Thank you OwenAuger
It really solved my problem and i learned a new formula =)