Forum Discussion
Formatting the graph
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
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
2 Replies
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