Formatting the graph

[Anonymous]

@v-kkf-msft Kindly help me here. I tried changing the measure but still created tickets are coming after closed tickets.

I want created tickets to be first in the graph and then the closed tickets.

Measure:

Combine =

var tab =

FILTER(

ALLSELECTED('devops-query-spr2'),

'devops-query-spr2'[Closed Month'Year] = MAX('devops-query-spr2'[Month'Year])

)

RETURN

IF(

MAX('Table'[Tickets]) = "Closed Tickets",

SWITCH(

MAX('Table'[Types]),

"Issue", CALCULATE( [Closed Issue], tab ),

"Feature", CALCULATE( [Closed Feature], tab ),

"User Story",CALCULATE([Closed User Story],tab ),

"UI/UX", CALCULATE( [Closed UI/UX count], tab ),

"Infra", CALCULATE( [closed Infrastructure], tab )

),

SWITCH(

MAX('Table'[Types]),

"Issue", [Issue],

"Feature", [Feature],

"User Story", [User Story],

"UI/UX", [UI/UX count],

"Infra", SUM('devops-query-spr2'[Infrastructure])

)

)

Regards,

Himanshu

[amitchandak · Accepted solution]

@Anonymous , create the columns

Ticket 1 =[Ticket]

Ticket Rank = Rankx(Table, [Ticket],,desc, dense)

Sort Ticket 1 on ticket Rank and use that in visual

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

[Anonymous]

@amitchandak It worked perfectly.

As always you're a saviour 😀

Regards,

Himanshu