topic Re: How to Create arrows showing increase and decrease of value in Developer

How to Create arrows showing increase and decrease of value

Anonymous — Fri, 06 Jan 2023 15:33:38 GMT

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.

Re: How to Create arrows showing increase and decrease of value

lbendlin — Sun, 08 Jan 2023 03:19:02 GMT

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-p/963216
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

Re: How to Create arrows showing increase and decrease of value

v-jianboli-msft — Mon, 09 Jan 2023 06:10:41 GMT

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.

Re: How to Create arrows showing increase and decrease of value

Anonymous — Mon, 09 Jan 2023 17:24:44 GMT

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.

Re: How to Create arrows showing increase and decrease of value

lbendlin — Mon, 09 Jan 2023 18:38:34 GMT

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

Re: How to Create arrows showing increase and decrease of value

Anonymous — Mon, 09 Jan 2023 19:08:55 GMT

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

Re: How to Create arrows showing increase and decrease of value

lbendlin — Mon, 09 Jan 2023 21:02:11 GMT

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

Re: How to Create arrows showing increase and decrease of value

Anonymous — Mon, 09 Jan 2023 21:14:11 GMT

Is there a way to apply conditions based on columns?

Re: How to Create arrows showing increase and decrease of value

v-jianboli-msft — Tue, 10 Jan 2023 01:22:19 GMT

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.