Change the transparency level of one bar in a stacked bar chart where year = 2022

[Anonymous]

Hi, 

I have a stacked bar chart (attached). I am looking to make the bar where year=22 a lighter color to indicate that we do not have full year data for that year. However, I am not able to find any documentation online on how to do this. 

Thanks, 

[jsaunders_zero9]

To do this I have created 2 measures for each gender filtering on the current year - History and Current Year. This will allow you to produce the below example.

If you have a file with sample data I can mock it up for you so you can see how to acheive it in your data.