Solved: Conditional formatting color for values with "p.p"

Anonymous · ‎08-25-2023

Hi everyone,

I've created a table with multiple measures, but I want the value to be with "p.p" after it, so the measure is:

X YoY% =

VAR __PREV_YEAR = CALCULATE([X], DATESBETWEEN('Calendar'[Date],date(2022,01,01),date(2022,12,31)))

VAR Y=

([X]- __PREV_YEAR)*100

RETURN format(Y, "# p.p.")

I want it like the 4th row for every rows, by p.p. and not %

And I want to make it green if > 0 or red if <0 , however, I have more than 20 measures, and do not want to create another 20 measures just for conditional formating. Is there a simpler way to do it?

Thank you!

parry2k · ‎08-25-2023

@Anonymous you can use dynamic formatting to control the look and feel and also create a measure for the color for condition formatting. From Thousands to Billions: The Power of Dynamic Formatting in Power BI - April 2023 Power BI Update - YouTube

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

parry2k · ‎08-25-2023

@Anonymous yes download the latest version, it will make life much easier.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous · ‎08-28-2023

@parry2k my latest version is from Aug 2023 and I don't see that option. Can you help pls?

Anonymous · ‎08-28-2023

Needed to enable it, thanks! For those who may need - Go to File -> Options and Settings – > Options -> Global -> Preview Features.

parry2k · ‎08-25-2023

@Anonymous you can use dynamic formatting to control the look and feel and also create a measure for the color for condition formatting. From Thousands to Billions: The Power of Dynamic Formatting in Power BI - April 2023 Power BI Update - YouTube

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.