Forum Discussion
Solved
Stacked Column Chart Last Date issue
Hello, I have the below stacked column charts. One is showing the totals by day and the other is showing the totals on the last day of the selected date range. The problem I have is the dark blue...
Just in case anyone stumbles onto this and has a similar issue I fixed it by removing day from the hierarchy and just using IF(ISFILTERED(table[date].[Month]/.[Quarter]/.[Year] statements with ENDOF_____ MONTH/QUARTER/YEAR.
Just in case anyone stumbles onto this and has a similar issue I fixed it by removing day from the hierarchy and just using IF(ISFILTERED(table[date].[Month]/.[Quarter]/.[Year] statements with ENDOF_____ MONTH/QUARTER/YEAR.