Forum Discussion
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 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
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.
4 Replies
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
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.
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.
