Forum Discussion
Dynamic Title based on selected month values on slicer
Super UserHi NeilJustice
The fact that your filter of the max of End of Month is showing as Sep-24 instead of Dec-24 is due to the fact that your month order is in alphabetical order instead of numerical order. What is the data type of your 'Date Table Invoice creation date'[End of Month]? It should be in a date format instead of text format.
Best regards,
Hi DataNinja777
This is now showing Dec 24 as you have stated above, so it works in that respect, but i dont want it to do that, i want it to show the previous full calendar month to what the current month is. So when nothing is selected, as of today i would expect to see the month for Apr 24 and this point in time next month (June) i would expect to see May 24 if nothing is selected. So the first part of the expression works fine, its just getting the second part to default to the previous month . cheers
Addition:-
I have amended the expression so that it now shows the previous month if none of the values in the slicer are selected. But it doesnt filter the values in the visual to show that month, It shows the totals for all the dates, i am guessing that this is because the visual is theoretically not being filtered, only the visual title. It only filters when i select a date in my slicer, how would we amend this to actually show the correct values when filtered.
The amended expression is