Comparison of two columns in percentage

[Anonymous]

Hi everyone,

I am getting stuck in solving my small issue, which is visualizing the difference between two different data in percentage. In this specific case in the screnshoot I am comparing only the years 2021 and 2022. However, my database is since 2008.

My goal here is to get the values in percentage comparing two different years in this column "Gesamt". How could I do that? Rememebring that my database contains data from year 2008 to 2024

And that's how I want to visualize the data.

Thank you in advance. 😃

[v-yadongf-msft · Accepted solution]

Hi @Anonymous ,

Please create a new column:

+/- % = [Y2021]-[Y2020]

Then create a new measure:

color = IF(MAX('Sheet4'[+/- %])<0,"#FF0000","#7CFC00")

Select “Conditional formatting” - “Font color”.

In font color page, select “Field value” and “color” measure.

Then you can get result you want.

Best regards,

Yadong Fang

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

[gauthamboppana]

@Anonymous  - Please check the below links for solutions. You will have to tailor the dataset and measures accordingly. Hope this helps !

https://community.powerbi.com/t5/Desktop/Percentage-change-across-matrix/m-p/210181

https://community.powerbi.com/t5/Desktop/How-to-calculate-percentage-change-between-two-dates/m-p/494008

Did I answer your question? Mark my post as a solution! If not, please feel free to ask me.

Also, I would ❤ Kudos if my solution helped.  It is a token of appreciation!

Thank you very much !

[collinq]

Hi @Anonymous ,

You might want to ask the question in the Dax/Developer area but the process would probably be to create a year over year percentage measure.  (There may even be a quick measure for that ) and then the measure would compare any two sequential years.