The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I have the following matrix below. I would like to add a background color for all the numerical values in Outflow row.(the Proceeds column, Allocation column , Audit column and Cost column). Can anyone help me with this?
Hi @dw700d,
If you apply what @amitchandak has provided for values, you can apply something similar on text-based columns by applying a few more steps as provided in this article by Matt Allington, here: https://exceleratorbi.com.au/conditional-formatting-with-a-text-field-in-power-bi/
Cheers.
Theo
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
@dw700d , Change of row color(conditional formatting) is not supported. You also fo conditional formatting in the matrix for the row column.
You can only color values. You can color all columns on values. based on a conditional to create row color
You can create a color measure and use that in conditional formatting using field value option
if(FIRSTNONBLANK(date[date],blank())= today(),"green","red")
or
Colour =
SWITCH(TRUE(),
'Table'[Date] < TODAY(), "red",
'Table'[Date] = TODAY(), "orange",
"green")
How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4