Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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. 😃
Solved! Go to Solution.
Hi @rosana ,
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.
Hi @rosana ,
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.
@rosana - 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/49...
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 !
Hi @rosana ,
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.
Proud to be a Datanaut!
Private message me for consulting or training needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.