Seperate rows

[Anonymous]

Hello, 

I want to seperate the tickets that are assigned to someone and thoes who are not. I dont want the name to appear in the Stacked Column Chart. I want the it to be three dirrent stacks: Assigend, Not assigned and Work in progress.

Kind Regards,

Albin

[Thejeswar · Accepted solution]

Hi @Anonymous,

Create a new Calculated Column with the following DAX Statement

New State = IF('Table'[Assigned To] = "","Not Assigned", 'Table'[State])

The Graph would look like the one below

The Below is my data for reference

StateAssigned To

Assigned	ABC
Assigned
Assigned	DEF
Work in Progress	GHI
Work in Progress	HUL
Work in Progress
Work in Progress
Assigned

[Anonymous · Accepted solution]

Hi @Anonymous

If this is your requirement then Create a Calculated Measure with the following DAX

State' = IF(Table1[assigned_to]=BLANK(),"Not Assign",Table1[State])

[Thejeswar · Accepted solution]

Hi @Anonymous,

Create a new Calculated Column with the following DAX Statement

New State = IF('Table'[Assigned To] = "","Not Assigned", 'Table'[State])

The Graph would look like the one below

The Below is my data for reference

StateAssigned To

Assigned	ABC
Assigned
Assigned	DEF
Work in Progress	GHI
Work in Progress	HUL
Work in Progress
Work in Progress
Assigned