Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi!
I have a matrix which looks like this:
The total column shows the average for the respective rows. I want to apply conditional formatting to the values based on the value in the Total Column. If the value is lower than the value in the total column it shoult be displayed in green and if it is higher it should be red. How can I achieve this?
Thank you!
Solved! Go to Solution.
Hi @Anonymous ,
You need to create a measure for the condittional formatting something similar to:
Coditional formatting = IF([Average]>= CALCULATE([Average];ALLSELECTED('Table'[Columns Category]));"#517d4f";"#b81818")
[Average] - Measure used for filling out the values in the matrix
If there is none create the following:
Average = Average(Table[Values])
Table[Columns Category] - the name of the column used on your columns in the matrix
Then use the condittional formatting Field Value and chosse the previous measure.
You can adjust the values in "" to the colours you want.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Anonymous ,
You need to create a measure for the condittional formatting something similar to:
Coditional formatting = IF([Average]>= CALCULATE([Average];ALLSELECTED('Table'[Columns Category]));"#517d4f";"#b81818")
[Average] - Measure used for filling out the values in the matrix
If there is none create the following:
Average = Average(Table[Values])
Table[Columns Category] - the name of the column used on your columns in the matrix
Then use the condittional formatting Field Value and chosse the previous measure.
You can adjust the values in "" to the colours you want.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi, I need some help, I'm failing at accomplishing this simple thing in Power BI.
I have a matrix with a few columns, one of them is a measure called DSO.
I would like to color DSO based on its total. If >=total,"Red"; if < Total, "green"
Thank you
you have to create a new measure, which you can use for formatting. This measure should calculate the total value, on each field on your matrix. You can achive that by the ALL function. Your screenshot does not show the measure on which the columns are based.
let's assume that column is mydimesion[mytype], your used measure is [mymeasure]
your formatting measure should be
myformatting measure=
calculate([mymeasure],ALL(mydimension[mytype]))
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |