Forum Discussion

Helper V

3 years ago

Solved

Conditional formatting specific quarters

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.

Tips and Tricks

Ahmedx
3 years ago
this is how you need it
need to create two calendar tables
https://dropmefiles.com/IRhlV

4 Replies

Ahmedx
Super User
3 years ago
so do you need?
https://dropmefiles.com/7pcq7
johnmelbourne
Helper V
3 years ago
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
  Super User
  3 years ago
  this is how you need it
  need to create two calendar tables
  https://dropmefiles.com/IRhlV
  - johnmelbourne
    Helper V
    3 years ago
    Amazing. Thanks so much, you are very talented.