How to Create arrows showing increase and decrease of value

[Anonymous]

Hello people,

I wanted to ask for help with a thing I am stuck on.  Using arrows, I need to show in the last column if the value has either increased or decreased. When tried conditional formatting, I was able to do the arrows pointing in upward direction showing increase in value but I am unable to show the downward arrow for decrease of value. I also tried DAX programming, but seems it didn't work either. Can someone here please guide me. Attaching my screenshot below for your reference. 

[v-jianboli-msft]

Hi @Anonymous ,

What does your raw data look like? You can use the if function or switch function for these two columns of data to return the comparison result as a value like 1, -1, and then do conditional formatting.

For example:

Measure2 = IF(SELECTEDVALUE('Table'[Prior Value])<SELECTEDVALUE('Table'[Current Value]),1,-1)

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-jianboli-msft · Accepted solution]

Hi @Anonymous ,

Based on your description, I have created a simple sample:

Please try:

Measure2 = IF(SELECTEDVALUE('Table'[Prior Value])<SELECTEDVALUE('Table'[Current Value]),1,-1)

Then apply it to the visual -> conditional formatting:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi There,

 Thanks for the solution, but not all rows are showing the right trends. 

Below is the conditional formatting condition used by me: 

I would appreciate it if you help me out with the right condition, been stuck here for past 3 days. 

[lbendlin]

in order for your measure to work correctly you need clean data.  Neither "NA"  nor "BBB+"  are numbers.

[Anonymous]

Hi, would you suggest null value in place of NA? also BBB is the Bond rating.

[lbendlin]

Use whatever data is appropriate in your scenario.  Don't mix numbers and text values.

[Anonymous]

Is there a way to apply conditions based on columns? 

[lbendlin]

Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523