Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |