Forum Discussion
Date data in Direct query
Hello All, I have created a data model in SQL to display LIVE Data of Sales, wherein I have a column of Date. The data is pulled into BI using "Direct Query". Though the date column is in Da...
That's possible but it isn't considering them as Date / Month / Year though I change the format from Text / Numbers to Date.
Then you can create a year column and month column then put them together with your date column in x axis.
What do you think? It will work as hierarchy as you drill down or up.
Tried that too !! Not working.