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.

Icey's avatar
Icey
Community Support
5 years ago

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'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.