blank year segmenter

[leomonfrinotti]

Good morning! It's the first time for me here!

I have the following problem... I have an excel dataset of a professional who is dedicated to interior design, from where I extract the data. It is a google sheet (quotes) that contains 6 columns of dates. They refer to the quote date, project start date, project end date, deposit date ($) of the project, payment date ($) of the second installment of the project and payment date ($) of the third installment. of the project. I have created a calendar table using variables, one variable takes the minimum date from the "quotation date" column and the other variable takes the maximum date from the "project end date" column. I have made my report with the years segmenter and this calendar table was taking the dates: minimum 02-01-2020 which corresponds to a quote issued that day and as maximum date 11-15-2022 which was the maximum date of the column project end date. Until this moment the Date Slicer of the years showed me 2020-2021-2022.

The problem occurred when a new sale was loaded in the dataset with "quotation date" 07-25-2022" and "project end date" 01-15-2023. From there, the year segmenter throws me a " Blank" staying like this (Blank)-2020-2021-2022-2023. I can't know why this "blank" legend is throwing me.

Next I upload some images of the relational model, the code of the calendar table, image of the dataset and the segmenter.

I await your response to see if you can help me. Thank you! Leonardo.

[leomonfrinotti · Accepted solution]

ya lo pude solucionar! Gracias.