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.
zoom slider was a real cool feature, but i didnt solve the problem really.
Insted of calculating filter values by days, I want it to calculate the values by month instead over the selected period.
I want the chart to look like this:
for a 2 year period, and not accumulated values each month.