Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I have a matrix in PowerBI with rows item category, item description, the column Year and the values Sales before Returns, Returns in Euro and Returns Quotas. The data looks like this:
Article Category | Item description | Revenue before returns | Returns in Euro | Returns rate | Year | Retourn |
B | C | 50 | 10 | 0,2 | 2021 | 0 |
B | D | 100 | 36 | 0,36 | 2019 | 1 |
A | E | 150 | 5 | 0,03333333 | 2022 | 1 |
A | F | 200 | 35 | 0,175 | 2019 | 0 |
B | C | 300 | 87 | 0,29 | 2022 | 1 |
B | D | 250 | 10 | 0,04 | 2019 | 1 |
A | E | 50 | 36 | 0,72 | 2019 | 1 |
A | F | 100 | 5 | 0,05 | 2019 | 1 |
In Power BI the matrix looks like this:
My client wants the Returns rate column to be formatted based on the total in that column.
If above the total value of the column, the formatting should be red, below green.
It try it using
Solved! Go to Solution.
I found a Soulotion.
First, I calculated the Amount of Return.
For the Color-Condion
Color 2 = if(Messure[returns rate]>Messure[returns per year], "red", "green")
I then used Color 2 as Field value in conditional formatting.
I found a Soulotion.
First, I calculated the Amount of Return.
For the Color-Condion
Color 2 = if(Messure[returns rate]>Messure[returns per year], "red", "green")
I then used Color 2 as Field value in conditional formatting.
k, so I think this video could help you.
around 11 minutes it is the same problem as you
hy dont you use conditionneal formatting, it will be easier
Since it then refers to the entire matrix and not to the column.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |