Forum Discussion
tsarun1992
Helper I
Helper IDate 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...
mussaenda
Community Champion
Community ChampionThen 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.
tsarun1992Helper I
Helper ITried that too !! Not working.