Different shade of color in bar chart for months not in Rolling 12?

[nleuck_101]

Hello All,

In the image below I have a Rolling 12 ticker with totals and a bar chart that has the last 13 months. A request was asked if I could color Jan 2021 a lighter shade of purple to show that it is not included in the Rolling 12 ticker totals. I didn't believe this to be an option in Power BI, but didn't know if anyone has tried something like this before or knows of way of doing this. A thought came to mind of a slicer that would highlight only the months in the Rolling 12 but a slicer won't highlight a chart it only filters it. Any ideas would be greatly appreciated.

Note: This data will update next month, so the Rolling 12 will be March-2021 through Feb-2022. That means Jan-2021 will go away and Feb-2021 becomes the new month that isn't apart of the Rolling 12 and needs to be a lighter shade. This process needs to be dynamic.

[v-yanjiang-msft · Accepted solution]

Hi @nleuck_101 ，

According to your description, here's my solution.

This is my sample data, the data type of the month column Date.

1.Create a calculated column Rank.

Rank = RANKX('Table','Table'[Month],,DESC,Dense)

Get the rank column based on the month.

2. Create a color measure.

Color = IF(MAX('Table'[Rank])=13,"#ec8fca", "Purple")

3.Select the visual, then under the Format tab, expand Data colors, there is a fx beside the Default color, click it.

Select the color measure as the based color.

Get the expected result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

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