How to Highlight or shade one quarter in a line graph?

[asalazarjr]

Hi, don't know if this is possible, but im trying to shade the background(Grey) of one specific quarter in a line graph. Trying to highlight the current quarter in a specific set of periods to help end-users understand which is the current quarter.

Any thoughts, or work arounds would be greatly appreciated!

[v-easonf-msft · Accepted solution]

Hi,  @asalazarjr 

You can try 'line and clustered chart'.

Use the value of the background height as the column value , and create a new measure to dynamically set the data color of the column.

Data colors of default color = 
IF (
    YEAR ( TODAY () ) = SELECTEDVALUE ( Table1[Date].[Year] )&&
    QUARTER ( TODAY () ) = SELECTEDVALUE ( Table1[Date].[QuarterNo] ),
    1,
    0
)

Reduce the inner padding to 0, you can get a similar visual.

Please check my sample  file for more details.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Fowmy]

@asalazarjr 

Check this video, hope it can be adapted for your scenario.

https://www.youtube.com/watch?v=Ds8Twy4VvzU