Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Conditional formatting for Decline Down Trend

I have  the data table . its having forur columns like 

 

Attributename              Feb          March     April 

  CFG                            96%          96%        99%

  CBL                            96%           98%       97%

 

I want  to use  up and down arrow for decline and increase based on month .

 

for Example CFG attribute March value same compare with   both same value so its should be yellow dash April Month its creased its should be up arrow . suppose april month if decline compare with march its should be down arrow .

 

Looking for support . thanks in advance 

Help me
Help Request
Help Requested
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous 

    You can create two measures to count the diff between two months , and then set conditional formatting for the measures .

    March diff = SWITCH(true,SELECTEDVALUE('Table'[Attributename])=SELECTEDVALUE('Table'[Attributename]) && SELECTEDVALUE('Table'[March])=SELECTEDVALUE('Table'[Feb]),0,SELECTEDVALUE('Table'[March])-SELECTEDVALUE('Table'[Feb]))
    April diff = SWITCH(true,SELECTEDVALUE('Table'[Attributename])=SELECTEDVALUE('Table'[Attributename]) && SELECTEDVALUE('Table'[April])=SELECTEDVALUE('Table'[March]),0,SELECTEDVALUE('Table'[April])-SELECTEDVALUE('Table'[March]))

    You will get a result like this :

    Then set conditional formatting for these two measures . Let's take [March diff] as an example . When the difference value is > 0, the rising arrow is displayed. If =0, parallel arrows are displayed. If < 0, show a falling arrow .

    The other measure has the same settings. The final result is shown in Fig.

    I have attached my pbix file , you can refer to it .

     

    Best Regards,
    Community Support Team _ Ailsa Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

     

     

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous 

    You can create two measures to count the diff between two months , and then set conditional formatting for the measures .

    March diff = SWITCH(true,SELECTEDVALUE('Table'[Attributename])=SELECTEDVALUE('Table'[Attributename]) && SELECTEDVALUE('Table'[March])=SELECTEDVALUE('Table'[Feb]),0,SELECTEDVALUE('Table'[March])-SELECTEDVALUE('Table'[Feb]))
    April diff = SWITCH(true,SELECTEDVALUE('Table'[Attributename])=SELECTEDVALUE('Table'[Attributename]) && SELECTEDVALUE('Table'[April])=SELECTEDVALUE('Table'[March]),0,SELECTEDVALUE('Table'[April])-SELECTEDVALUE('Table'[March]))

    You will get a result like this :

    Then set conditional formatting for these two measures . Let's take [March diff] as an example . When the difference value is > 0, the rising arrow is displayed. If =0, parallel arrows are displayed. If < 0, show a falling arrow .

    The other measure has the same settings. The final result is shown in Fig.

    I have attached my pbix file , you can refer to it .

     

    Best Regards,
    Community Support Team _ Ailsa Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.