Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
SaranyaSandeep
Regular Visitor

How to get different background colour for each quarters?

I need to acheive the following in a line graph,

In my case, X-axis is FiscalMonth. Y-axis has a measure with years as legends. Here I need to represent 1st 3 months (Apr, may, June-Quarter1) background in one colour, next 3 months(July,Aug,Sep-Quarter2) in another colour, next 3 months(Oct,Nov,Dec-Quarter3) in same colour as Quarter1 and next 3 months(Jan,Feb,Mar-Quarter4) in same colour as Quarter2. I know that X-axis constant line can be used only if the X-axis is date or numeric data type, but in my case its string. Is there any other ways (Dax queries/calculated fields/formulae) to acheive the same? Please refer the below screenshots,

SaranyaSandeep_0-1679431531356.png

What I need is,

SaranyaSandeep_1-1679431691350.png

I have done this by placing a text box and filling it with grey, but it's static box which will not change if I apply any filter and the data in the graph changes.

I wnat the background to be dynamically adopting even if I apply a filter. Q1,Q2 should be in 1 color and Q2,Q4 should be in 1 colour. 

 

Thanks in advance

Saranya

 

1 REPLY 1
Anonymous
Not applicable

Hi @SaranyaSandeep ,

As far as I concerned, this is by design. Power BI is now unable to achieve what you need . You can vote the idea here: Multicolored background of a visual e.g Line Chart according to the values on Line     and wait for users with the same needs as you to vote to help make it happen as soon as possible.

 

I ahve also found a similar post, please refer to it to see if it helps you.

Solved: Background colour in line charts - Microsoft Power BI Community

 

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors