Forum Discussion

ajdm2007's avatar
ajdm2007
Helper III
1 year ago
Solved

Adding specialist picture

Hello everyone,

I hope you had a happy holiday season with all your loved ones and that this new year 2025 you reach all your goals.

I'm a Call Center Supervisor and since last year I have been working on developing a report in Power BI that shows the performance of the team. This is with the objective of highlighting performance but at the same time looking at opportunities for improvement.

That is why I have done this:

What you see is basically a table with some indicators and at the bottom considering the indicators of the table I determine who goes in each position.

So far everything is working fine, only that I would like to add the image of the specialist dynamically and as well as the name could change month to month could also change the image.

I have a table of specialist in which there is a column that has the PhotoURL where I have hosted the image, but I don't know how I can make this image is displayed in a card type display because the idea is that above the position is the image, then the position and below the name of the person.

To calculate the most effective I use the following formula:

 

most_effective_specialist = 
MINX(TOPN(1,
ADDCOLUMNS(
SUMMARIZE(specialist,[Name]),"Rank",[effective_rank]),[Rank],ASC),specialist[Name])

Any idea how to extract the photo, taking that metric as a guide?

 

Thank you very much.

 

Need Help
Show and Tell
Tips and Tricks
  • ajdm2007's avatar
    ajdm2007
    1 year ago

    Hello lbendlin 

     

    Thank you for your advise. I'll keep it on mind.

     

    I have already solved the problem of the formulas, I leave a sample for future reference:

     

    most_effective_specialist = 
MINX(TOPN(1,
ADDCOLUMNS(
SUMMARIZE(specialist,[Name]),"Rank",[effective_rank]),[Rank],ASC),specialist[Name])

     

    most_effective_specialist_photo = 
VAR EffectiveSpecialist =
    MINX(
        TOPN(
            1,
            ADDCOLUMNS(
                SUMMARIZE(specialist, specialist[Name]),
                "Rank", [effective_rank]
            ),
            [Rank], ASC
        ),
        specialist[Name]
    )
RETURN
    CALCULATE(
        MAX(specialist[PhotoURL]),
        specialist[Name] = EffectiveSpecialist
    )

     

3 Replies

    • ajdm2007's avatar
      ajdm2007
      Helper III
      1 year ago

      Hello lbendlin 

       

      Thank you for your advise. I'll keep it on mind.

       

      I have already solved the problem of the formulas, I leave a sample for future reference:

       

      most_effective_specialist = 
MINX(TOPN(1,
ADDCOLUMNS(
SUMMARIZE(specialist,[Name]),"Rank",[effective_rank]),[Rank],ASC),specialist[Name])

       

      most_effective_specialist_photo = 
VAR EffectiveSpecialist =
    MINX(
        TOPN(
            1,
            ADDCOLUMNS(
                SUMMARIZE(specialist, specialist[Name]),
                "Rank", [effective_rank]
            ),
            [Rank], ASC
        ),
        specialist[Name]
    )
RETURN
    CALCULATE(
        MAX(specialist[PhotoURL]),
        specialist[Name] = EffectiveSpecialist
    )

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi ajdm2007 

        It is glad that you have solved the problem, you can accept your answer as a solution so that more user can refer to if they have the similar problems.

         

        Best Regards!

        Yolo Zhu