Forum Discussion
Column graph
Dear Experts
I have a column chart like below & I am using the below measure to get this result
what I want to do is to show Week 16 in a different color, is that possible?
i am not able to find a way
vjnvinod , Please replace color with hex code , replace with one you want
eaxmple
SWITCH (
TRUE (),
MAX ( Week_Tbl[CurrentWeek] ) = MAX ( Week_Tbl[Index] ), "#0000FF",
MAX ( Week_Tbl[Index] ) < MAX ( Week_Tbl[CurrentWeek] ), "#00FF00",
MAX ( Week_Tbl[Index] ) > MAX ( Week_Tbl[CurrentWeek] ), "#FFFF00"
)
4 Replies
vjnvinod , You can not show if they are two measures. If you are sure both these measure will not have overlapping data add them
m1 = [EWF 4 weeks EU %] +[FWD Utilization %]
No based on logic if week 16 is current week or max selected week etc, create a color measure and use that in conditional formatting using the field value option
example
Switch(True(),
max(Date[week]) <16, "Blue",
max(Date[week]) =16, "Red",
max(Date[week]) >16, "Yellow"
)
How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4
I actually don't have the dates in my week table
However, I was trying to create the measure as you mention, but not successful though
let me know how to create the measure, that will be helpful
It worked well & I looked at your youtube video, amazing
But you didn't explain how to use Hexa code, how do I change the below measure to Hexa code?
SWITCH (
TRUE (),
MAX ( Week_Tbl[CurrentWeek] ) = MAX ( Week_Tbl[Index] ), "Blue",
MAX ( Week_Tbl[Index] ) < MAX ( Week_Tbl[CurrentWeek] ), "Green",
MAX ( Week_Tbl[Index] ) > MAX ( Week_Tbl[CurrentWeek] ), "Yellow"
)
