How to make Qtr Bar chart all Q1 same color and Q2 same color.

[admin11]

Hi All

I have a Qtr bar chart , i like to make all Q1 bar same color . i have try measure  , i get error :-

color by qtr = Switch(max('Date'[year]),
Q1, "green",
Q2, "blue",
Q3, "red",
Q4"grey"
)

My PBI file :-

https://www.dropbox.com/s/bcxgotj4edvdtqe/PBT_V2021_392%20TI_SI_GL%20Qtr%20Q1%20bar%20all%20same%20c...

Paul

[PhilipTreacy · Accepted solution]

@admin11 

Hi Paul,

Download PBIX

This code works

color by qtr = 

VAR __Qtr = SELECTEDVALUE('Date'[Year Quarter])

RETURN

SWITCH(
    
    TRUE(),
    

    CONTAINSSTRING(__Qtr, "Q1"), "green",

    CONTAINSSTRING(__Qtr, "Q2"), "blue",

    CONTAINSSTRING(__Qtr, "Q3"), "red",

    "gray"
)

Regards

Phil

[v-yiruan-msft · Accepted solution]

Hi @admin11 ,

Please update the formula of measure [color by qtr] as below:

color by qtr = 
SWITCH (
    RIGHT ( SELECTEDVALUE ( 'Date'[yrqtr] ), 2 ),
    "1Q", "Green",
    "2Q", "Blue",
    "3Q", "Red",
    "4Q", "Grey"
)

Best Regards

[admin11]

@v-yiruan-msft 

Thank you very much for your help , it work fine , apprecaite a lot.

Paul

[PhilipTreacy]

@admin11 

Hi Paul,

Didn't my code work?  It produces the results you asked for?

Phil

[PhilipTreacy · Accepted solution]

@admin11 

Hi Paul,

Download PBIX

This code works

color by qtr = 

VAR __Qtr = SELECTEDVALUE('Date'[Year Quarter])

RETURN

SWITCH(
    
    TRUE(),
    

    CONTAINSSTRING(__Qtr, "Q1"), "green",

    CONTAINSSTRING(__Qtr, "Q2"), "blue",

    CONTAINSSTRING(__Qtr, "Q3"), "red",

    "gray"
)

Regards

Phil

[admin11]

@PhilipTreacy 

I am sorry , i miss your reply. i just tested your is working fine.

also your code more easy to understand.

Paul