Column graph

[vjnvinod]

Dear Experts

I have a column chart like below & I am using the below measure to get this result

EWF 4 weeks EU % = CALCULATE(

DIVIDE (

SUM ( Executive_Weekly_Flash_Consolidated[Actual CH Hrs] ),

SUM ( Executive_Weekly_Flash_Consolidated[Actual EAH] )

),Executive_Weekly_Flash_Consolidated[Period]="WTD",Week_Tbl[Visibility25])

FWD Utilization % =

CALCULATE (

DIVIDE (

SUM ( 'Mercury_Extract'[Chargable] ),

SUM ( Mercury_Extract[Standard Hrs]) - SUM ( Mercury_Extract[Holiday] )

),

Week_Tbl[Visibility19]

)

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

[amitchandak]

@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

[vjnvinod]

@amitchandak 

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

[vjnvinod]

@amitchandak 

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"

)

[amitchandak · Accepted solution]

@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"

)