Forum Discussion
Solved
Date representation on line chart
This is probalby an easy fix, but I`m not able to change the "date resolution" on the line chart. It will only give me days and not month/quarter/Year. so the line over a 2 year period gets very clus...
Ruga , You can create a date table and use month, qtr and year from there.
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
I added "beggining of month" to the date table lookup, and use this as a date in the line chart.
Thanks for your tips