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.
Dear community,
I have the following problem creating a conditional formatting in a column chart:
In the visual there is no graduation shown, all columns have the same color.
I created this matrix visual, where data is shown like this:
Name | Difference | Margin Index |
Product A | 31055 | 84,22179718 |
Product B | 18916 | 110,8132923 |
Product C | -17224 | 79,34762554 |
Product D | -23317 | 9,246055122 |
Then I created a column chart shows the value "Difference" for each product.
I have set a conditional formatting for the chart based on the field "Margin Index" with min-max option selected.
All the columns have the same color, there is no graduation. Also, when I drag the field "Margin Index" into "QuickInfo", every column shows the same value (440.000).
"Name" and "Difference" come from table A, "Margin Index" is a calculation in table B.
The tables are joined based on "Name" from table B to table A.
In the table structure of table A, each product has several entries. In table B, there is only 1 entry for each product (sample below)
table A:
Name | Difference |
Product A | 10 |
Product A | 15 |
Product A | 100 |
… | |
table B: | |
Name | Margin Index |
Product A | 84,22179718 |
Product B | 110,8132923 |
Product C | 79,34762554 |
Product D | 9,246055122 |
Any idea?
Solved! Go to Solution.
hi @skean21
You just need to adjust it by these two ways:
"Name" and "Difference" come from table A, "Margin Index" is a calculation in table B.
1. Please use "Name" from table B.
2. Set cross filter direction is "Both" instead of "Single"
Then it should work.
Regards,
Lin
hi @skean21
You just need to adjust it by these two ways:
"Name" and "Difference" come from table A, "Margin Index" is a calculation in table B.
1. Please use "Name" from table B.
2. Set cross filter direction is "Both" instead of "Single"
Then it should work.
Regards,
Lin
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 |
---|---|
56 | |
19 | |
18 | |
18 | |
9 |