Need help creating matrix visual with lookupvalue function

Anonymous — Tue, 21 Feb 2023 07:28:48 GMT

I have a table that has four columns: key, parentKey, TicketType, summary.
The columns are defined as:
key - unique value of each ticket(will have IDs for all types of tickets including epics, stories, tasks and bugs)

parentKey - will be the key of epic under which other ticket types are present(bug, story and task) *value will be blank for epics

TicketType - categorical column with four values: Epic, Story, Task, Bug

Summary - Short description of each ticket (will have summaries for all types of tickets including epics, stories, tasks and bugs)

I want to create a matrix visual where parentKey and key are selected in rows (such that keys of stories, tasks and bugs mapped to an epic is displayed under the key of the epic) as shown in the 1st figure below and correspondingly the summary of the epic/story/task/bug in the values field.

The resultant table I have got is not showing the summary of the epic. Rather it is displaying the summary of one of the ticket types that is matched under it. How can I correct this visual to show summary of the epic correctly?

Pic 1 - Resultant Matrix Visual

Pic 2 - Parameters selected for generating matrix

Pic 3 - Sample data

Visual: Summary IssueVisual ParametersTable

Re: Need help creating matrix visual with lookupvalue function

Anonymous — Thu, 23 Feb 2023 05:52:39 GMT

Hi @Anonymous ,

You can create a calculated column as below and replace the field [parentkey] on the matrix. Please find the details in the attachment.

New Parentkey = IF ( 'Table'[parentkey] = BLANK (), 'Table'[key], 'Table'[parentkey] )

Best Regards

topic Re: Need help creating matrix visual with lookupvalue function in Developer

Need help creating matrix visual with lookupvalue function

Re: Need help creating matrix visual with lookupvalue function