Question about Tooltips

[Anonymous]

Hello

i want to create in powerbi  analog dashboard like in Azure DevOps (Boards):

on my Matrix Table visulisation diplay more detain information (work item id, min,max and etc) which and want add to Tooltips, but if i added those values, they aren't correct dispplay, view total value (but i want view by work item id, in example bellow i want to view max Cycle Time of work items is 22 

[Icey]

Hi @Anonymous ,

But in your data, the max Cycle Time of work items is "33". Why do you want to show "22"? Are there any rules?

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[Anonymous]

i want to display ID for different values (for max,min, mediana).

I know how found min/max/mediana values, but i can't know how found ID for thsse values, i think about:

var a = MAX(...)

var b = LOOKUPVALUE(
items[Work Item Id],items[TT],a)

return b

[Icey · Accepted solution]

Hi @Anonymous ,

Please check if this is what you want:

WorkItem of MaxCycleTime =
VAR MaxCycleTime =
    MAXX (
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[WeekNum] = MAX ( 'Table'[WeekNum] ) ),
        [Cycle Time]
    )
VAR t =
    FILTER ( 'Table', 'Table'[Cycle Time] = MaxCycleTime )
RETURN
    CONCATENATEX ( t, [WorkItem], ", " )

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[amitchandak]

@Anonymous , I think you have use isinscope and force different subtotal -https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

Or you can create a meausre to give that value and add that to tooltip or create a tooltip page with such a measure

https://docs.microsoft.com/en-us/power-bi/desktop-tooltips