Grouping years superior to 2021

[Anonymous]

Hello,

I want to represent on a clustered chart data over the years  like this

I don't need to represent 2021,2022,2023, etc.. So, start from 2021, I want to group years 

I managed to do it by a Calculated Column, but it's a String column..Therefore, all my Time Intelligence evolution are wrong

So I wonder if it's possible to group Years on a clustered chart by an easy way ?

thanks !

[Anonymous]

the tooltip is driving me crazy 🙂 

I use you file @v-frfei-msft  and I've added 2 columns, one with some ID's and one equals to Year - 1

I've joined the file here

First I calculate how many projects there are 

#Nb_Projects = DISTINCTCOUNT(Table1[ID])

Depending on which bar I roll over, I want to display how many projects on the year before

But it keeps displaying the value of the year rolled over....

My measure

#YearBefore = 

var whichYear = SELECTEDVALUE(Table1[Year])
var groupYear = SELECTEDVALUE(Table1[Column])

var year_n1 = SELECTEDVALUE(Table1[Year - 1])
var yearToCompare = if(groupYear="above 2021";2020;year_n1)
return

CALCULATE([#Nb_Projects];Table1[Year - 1]=yearToCompare)

Many thanks!

I've joined the file here

[Anonymous]

anyone knows how I can display the evolution between bars in that case ? 

[v-frfei-msft]

Hi @Anonymous ,

One sample for your reference, please check the following steps as below.

1. Change the data type of Year column to Number.

2. Create a calculated column using the formula sa below.

Column = IF(Table1[Year]>=2021,"above 2021",""&Table1[Year])

3. Then we can get the visual as we excepted.

Alternatively, we can gourp the column directly. Please refer to the screen shots as below.

Pbix as attached.

[Anonymous]

Hi @v-frfei-msft 

thanks for your answer. It's pretty much the same of my attempt actually.

At the end, the calculated column "Column" is a text. Therefore the time intelligence evolution between the different bars can't work because Power BI expects a year

I feel I have no choice to create that kind of measure (quick measure) ....

....but adapted to a text type column

Do you understand what I mean?