Forum Discussion
Column graph
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"
)
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"
)
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"
)