Forum Discussion

JanaeWalker864's avatar
JanaeWalker864
Frequent Visitor
3 years ago

Past Due Bucket Date

I have a Power BI Matrix visual. Within the Power Bi matrix I have my values across rows and my months in my columns as illustrated. Anything that is considered past due is placed under the date of 12/25 of the previous year within my ETL process. What I would like to see instead of the December month in this visual is for it to say "Past Due" up at the top. How can I make this possible 

 

1 Reply

  • Create a calculated column in your calendar table that either contains the yearmonth string or the "Past Due"  string.   You'll need to figure out the sort order though.