How to color only a specific month?

Question & Answer
,
1

Hello there, I have a dashboard that shows some metrics over the last 6 months and the data is D-1. Is there a way to have a different color only to the most recent month?
Just like in Tableau, I have created a calculated field to distinguish which is the most recent month, but when in color, the result is not what I expected, since it seems that for each month is created a true or false making the bars narrower and a not very good visual.
The image uploaded shows what I expected and what really happened.

example
example2088Ă—1336 20.7 KB

Thanks for your help!

2

Hi @tiagovicente
you want to use the “calculated field” as a value in the bar chart or only want to color the most recent month?

If last one you could try to use a stacked bar chart.

grafik
grafik1244Ă—479 37.9 KB

BR

2 Likes
3

@tiagovicente I have created a sample in below, please take a look. thanks!
https://community.amazonquicksight.com#Arena-dashboardId=ae1604c5-f39e-4e8c-8cb9-1d5dcdcacd80&authorId=CU-852

image
image2418Ă—1288 206 KB

2 Likes
4

@ErikG and @royyung, thanks for the replies!
The suggestion for using stacked bar chart worked really well with the calculated field.

2 Likes