Forum Discussion
Anonymous
5 years agoNot applicable
edit graph
I want to edit graph from pic1 to pic2 guide ma about it please. Pic 1 Pic2
v-kkf-msft
5 years agoCommunity Support
Hi Anonymous ,
Create a calculate column:
Sort Order =
var a =
CALCULATE(
COUNTROWS('Table'),
FILTER(
ALL('Table'),
'Table'[Developing_In_month] <= EARLIER('Table'[Developing_In_month])
&&'Table'[Status_2021] = "on the way"
)
)
return
SWITCH(
'Table'[Status_2021],
"on the way",1+0.1*a,
"Deploy", 2,
"Get requirement", 3,
"Completed", 4,
5
)
Select the Code column, and select the Sort Order column in the Sort by column drop-down list.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
5 years agoNot applicable
v-kkf-msft I want to show in graph .
But order by sort.