Question about labels

[Anonymous]

Hello everyone, good afternoon.

In my report I have this graph:

This graph shows the production through vertical bars alongside the cumulative goal represented by dashed lines. Currently, the labels indicate the percentage of production relative to the accumulated goal. My inquiry pertains to the following:

Is it possible to modify the labels to showcase the ranking of each supervisor? The parameter for this ranking would be based on performance rather than production. I would appreciate insights on the viability of implementing this adjustment.

So it would look similar to this:

You get the idea

The measure needs to be dynamic as I intend to apply filters based on date and location. Once the measure is done, I plan to implement a conditional statement like the following:

IF ( supervisor_ranking = 1, supervisor_ranking, "")

To display only the top ranked lable.

Hopefully I've made myself clear.

Thanks in advance.

[Anonymous]

That's how the table looks

The whole goal of my question is to put a STAR on top of the top-ranked supervisor (using custom label functionality). Like this:

[Greg_Deckler]

@Anonymous Not sure I am entirely clear but it seems like you essentially need a "Sort by column" except that won't exactly work because you need the sorting to be dynamic. Not sure there is a solution for that.

[Anonymous]

@Greg_Deckler , thanks for the reply.

Let me try to explain. Power BI has recently introduced a new feature called "Custom Label." I am exploring the possibility of utilizing this function to generate a custom label that displays the rank of each supervisor. Specifically, I am interested in understanding the feasibility of creating a measure that calculates the rank based on the performance of the supervisor.

So when I filter the months or date I could see who was the top-ranked supervisor based on their performance, not solely on production metrics.

[Greg_Deckler · Accepted solution]

@Anonymous Ah, got it. Yes, you can use a measure for the Value field for data labels so you should be able to code this to whatever you want. You will need to do a ranking of ALL the supervisors and then determine if the current context supervisor is the top 1 (or whatever your logic) and you could return a UNICHAR of a star for example for the top on.

[Anonymous]

Now the only problem is this

Instead of displaying the ⭐ it simply shows the code (I'm using the Power BI Report Service in PBI Desktop works just fine).

[Anonymous]

@Greg_Deckler , thank you very much!
This measure
RANKX(
ALL(producao[supervisor]),
[performance],,DESC,Dense
)
did the job.