Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Question about Tooltips

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 ...
Need Help
  • Icey's avatar
    Icey
    5 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
Icey
Community Support
5 years ago

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.