Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello all,
can you please help me with the following problem. It is possible to color in the column chart according to the target while every month is a different target?
Red if the value is lower than the target, Green if the value is higher.
I want to use Line and stacked column chart. While Line represents the target.
Thank you
Michael
Solved! Go to Solution.
I believe this is your expectation,
1. Create a measure by making necessary changes based on your tablename.
CF =
IF(SUM('Table (2)'[Value])<SUM('Table (2)'[Target]),1,0)
2. Go to conditional formatting pane, click and open fx in the column option.
3. And select the Format style as rule and field as measure name and the choose the colors for the given condition.
Thanks,
Arul
I believe this is your expectation,
1. Create a measure by making necessary changes based on your tablename.
CF =
IF(SUM('Table (2)'[Value])<SUM('Table (2)'[Target]),1,0)
2. Go to conditional formatting pane, click and open fx in the column option.
3. And select the Format style as rule and field as measure name and the choose the colors for the given condition.
Thanks,
Arul
Perfect !!! It works. Thank you very much.
User | Count |
---|---|
93 | |
83 | |
77 | |
72 | |
66 |
User | Count |
---|---|
115 | |
103 | |
93 | |
64 | |
61 |