Conditional formatting for Decline Down Trend

Anonymous — Wed, 08 Jun 2022 07:56:58 GMT

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

Re: Conditional formatting for Decline Down Trend

Anonymous — Mon, 13 Jun 2022 08:27:55 GMT

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.

topic Conditional formatting for Decline Down Trend in DAX Commands and Tips

Conditional formatting for Decline Down Trend

Re: Conditional formatting for Decline Down Trend