Forum Discussion
JanaeWalker864
3 years agoFrequent Visitor
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
- lbendlinSuper User
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.