Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How to display different image based on different measure

so there are different project status, and category, i will be doing a measure, if all project in that category is completed, will be "Completed" or "Incomplete". I will like to find a way to dispay tick or cross based on completee or incomplete. How can i do it?

Thanks in advance

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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
_result

    change 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

5 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    Anonymous , Create a text measure as image URL(Text make are Image URL in category)  , make sure that URL is accessible

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      hi can u tell me how to do it exactly?

      im still new to powerbi

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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
_result

    change 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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi, i have encounter a new problem, can i juz show this measure as an image only? but not inserting it into the table. 

    • Celia92's avatar
      Celia92
      Frequent Visitor
      3 years ago

      HI!! Where did you get that URL? I get from flaticon but it doesn't show the picture correctly.

      Thanks ğŸ™‚