Forum Discussion
Community ChampionVisual showing more dates than available in column
Thanks LivioLanzo
I tried marking it as Date table and the hierarchy that had earlier been created automatically has disappeared. Now I'm back to the option where I selected Date in the filed menu as opposed to Date hierarchy (since this doesn't exist any more). It works normally now, showing only the dates in the column instead f the full year and responding to the slicer. Any idea about why this change after marking the table as Date? What happens exactly when you do that?
What do you mean by the " 'default' Date table"? What do you use instead?
Thanks
Community ChampionThanks LivioLanzo
I tried marking it as Date table and the hierarchy that had earlier been created automatically has disappeared. Now I'm back to the option where I selected Date in the filed menu as opposed to Date hierarchy (since this doesn't exist any more). It works normally now, showing only the dates in the column instead f the full year and responding to the slicer. Any idea about why this change after marking the table as Date? What happens exactly when you do that?
What do you mean by the " 'default' Date table"? What do you use instead?
Thanks
Solution SageHi AlB
By default Date Table I meant the one that Power BI automatically creates when you do not mark it as a 'Date Table'
Here is the documentation info: https://docs.microsoft.com/en-us/power-bi/desktop-date-tables
- AlB
Cool. Thanks LivioLanzo. I'll have a look at the documentation