Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Original post: Matrix computed row - to show computed columns wit... - Microsoft Fabric Community
Hi @v-cgao-msft, I encounter another issue whereby when I want to set the font colour based on value:
<0, show as red
>0, show as green
But the condition setting determine the column 'Actual - Plan' as Text:
I will need to set as below:
Appreciate your kind support to share the solution, thank you very much!
@emmalim isn't this what you want?
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.
@parry2k I need to applied the colours to column Actual - Plan. But this column is seems like detected as 'text', hence I cannot apply the conditional formatting as per column _Actual 2.
Appreciate your support to share the alternative, thank you very much.
@emmalim why -ve is in red and +ve in green, although I think you want it the opposite, no?
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.
@emmalim is this what you are looking for:
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.
@parry2k Thanks for your reply. Unfortunately this is not what I'm looking for, sorry for not being precise in the earlier post. The desire result is as per column _Actual 2 below, but i need it to be applied to column Actual - Plan:
BI file:
Hello @emmalim ,
Yes, you can't set the Actual plan as >0 or < 0 because you merged the columns so it is considered text and not number.
it's either you subtract them or sum them to have a number value then you could do a conditional formatting based on what you've mentioned.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote For my Idea💡
Proud to be a Super User! | |
@Idrissshatila Thanks for your reply. I actually substract 2 measures. Attached the file for your reference. Appreciation your kind support to advice the alternative to show the conditional formatting colour.
BI file:
P&L Sample