Forum Discussion
How to display different image based on different measure
Hi Anonymous ,
Suppose we have a table like:
then please new a mesure like:
Measure = VAR _countrows_1 = DISTINCTCOUNT('Table'[Status]) VAR _countrows_2 = CALCULATE(DISTINCTCOUNT('Table'[Status]),'Table'[Status]="Completed") VAR _result = IF(_countrows_1=1&&_countrows_2=1,"https://cdn-icons-png.flaticon.com/512/190/190411.png","https://cdn-icons-png.flaticon.com/512/190/190406.png") RETURN _resultchange the data category to 'Image URL':
result:
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi Anonymous ,
Suppose we have a table like:
then please new a mesure like:
Measure =
VAR _countrows_1 = DISTINCTCOUNT('Table'[Status])
VAR _countrows_2 = CALCULATE(DISTINCTCOUNT('Table'[Status]),'Table'[Status]="Completed")
VAR _result = IF(_countrows_1=1&&_countrows_2=1,"https://cdn-icons-png.flaticon.com/512/190/190411.png","https://cdn-icons-png.flaticon.com/512/190/190406.png")
RETURN
_resultchange the data category to 'Image URL':
result:
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi, i have encounter a new problem, can i juz show this measure as an image only? but not inserting it into the table.
HI!! Where did you get that URL? I get from flaticon but it doesn't show the picture correctly.
Thanks 🙂
