Line and stacked column chart

[Pallavi_m]

Hi,

I have a chart like this.

Now, I have an year column on x-axis. 

Year

2015

2016

2017

2018

2019

2020

2021

2022

2023

2024

I have already claculated measures like total sales etc., on y-axis.

requirement: i want years 2015... 2021 to be grouped under A and coloured in grey

 and current year(2022 , 2023 ,2024 ) to be grouped under B and coloured in blue.

Help is appreciated

requirement:

[Arul · Accepted solution]

@Pallavi_m ,

I hope below are your expectation.
Expected existing:

Expected Outcome:

To achieve this, you have to create a calculated column with the below code and use it in your visual.

Group =
IF ( Sales[Year] >= 2015 && Sales[Year] <= 2021, "A", "B" )

To change the colors. go to the visual format pane. Under the format pane choose columns and enable show all and change the color to grey for A and Blue for B.

Thanks,

[Pallavi_m]

Hi @Arul ,

Thanks for the solution.

Group =
IF ( Sales[Year]  <= 2021 && sales[MonthNo]= Month(now()-1,
 [measure1],[measure2] )

when I wrote this Calculated column, it says circular dependency was detected.

How do I avoid this?

[v-shex-msft]

Hi @Pallavi_m,

You can write a measure formula to compaore current year and the specific year range to return color code, then you can use it on data color conditional formatting.

Regards,

Xiaoxin Sheng