How to Label data with certain value

[JustinDoh1]

Hi 

I am sharing my Pbix file here and also attached.

I am trying to label (Blank) on this bar chart with something like "Prior to 2021".

I have a dim table (Calendar) that starts from 1/1/2021.

But, the fact table (Data)'s TransactionDate value starts from Jan 2020, and that caused the Blank value issue.

Is there way to lable on a new column using something like

("Prior 2021") = where TransactionDate < "01/01/2021" ? 

Expected output:

Thanks.

[sevenhills · Accepted solution]

My 2 cents:

In my view, You are seeing blank value in the chart because Data table has more dimension date data than in the Calendar table.  Calendar table needs to be fixed by having all dates that are in fact table. (Note: you are doing is cumulative sum, hence you must have all dates in my view.)

Once you have all the dates in the Calendar table, you can add a new column (or) adjust your "Year-MonthName" column per your needs 
i.e., "Prior 2021" for 2020 and below dates;  and for 2021 and above as "YYYY MMM"