Forum Discussion

Helper I

3 years ago

Solved

Line and stacked column chart

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
3 years ago
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,

3 Replies

Arul
Super User
3 years ago
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
  Helper I
  3 years ago
  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?
Anonymous
Not applicable
3 years ago
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