Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

edit graph

I want to edit graph from  pic1 to pic2  guide ma about it please.     Pic 1   Pic2  
Need Help
v-kkf-msft's avatar
v-kkf-msft
Community Support
5 years ago

Hi Anonymous ,

Modify calculated column Sort_Order:

Sort_Order = 
var a = 
    CALCULATE(
        COUNTROWS('Table'),
        FILTER(
            ALL('Table'),
            ('Table'[Developing_In_month]+'Table'[Developing_Last_Month]) <= EARLIER('Table'[Developing_In_month]) + EARLIER('Table'[Developing_Last_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
    )

Best Regards,
Winniz

Anonymous's avatar
Anonymous
Not applicable
5 years ago

v-kkf-msft   It show can't display the visual same (python)

 

 

 

my data have 120 rows and 35 columns.

 

Help me please.