Conditional formatting specific quarters

[johnmelbourne]

Hi all,

Is there a way I could create this chart in Power BI?

Where the current quarter is a colour,

the same quarter in previous years is a lighted shade,

all other quarters are grey?

Thanks for any advice.

[johnmelbourne]

Your solution is so good, and nearly what I need.  I don't need to the currrent quarter, I need to highlight the quarter selected in the slicer (obviously in a non-connected chart). 

I have updated your pbix here with guidance. https://dropmefiles.com/pk6dF

[Ahmedx · Accepted solution]

this is how you need it
need to create two calendar tables

https://dropmefiles.com/IRhlV

[johnmelbourne]

Amazing. Thanks so much, you are very talented.

[Ahmedx]

so do you need?

https://dropmefiles.com/7pcq7