Hi Srikar N
Below Points May Help you to Solve your Problem
1- go to File -> work locale -> more -> Select Your County (Ex. English(India))
2- go to Date Default Property -> Custom -> write in format box mm yyyy
Sorry i am not able to open your .Twbx due to some technicality, if still some specific requirement please let me know.
I tried those options still no luck.
Thanks for looking into it.
Request you to please share the .twbx file where you have fixed this issue. Thank you.
1 of 1 people found this helpful
If you filter for the month it should give you all the data that matches that month. In the superstore data it looks like there are no entries for Jan 1 and 2 2013 so that is why it is showing Jan 3 I believe. I did it slightly different than Alok, I created a custom data from order date:
change the default format to mm/yyyy for Order Date (Months)
now if you put this on filter instead, it will only show the month and year (and also will not give the drop down calendar)
but since this is essential a higher hierarchical element, it should behave as you want. we can see this if we look at the relationship of [Order Date (Months)] to [Order Date]:
if we were to right click on 01/2013 and select "Keep Only" we would get all of the dates in January of 2013 (for which there is data)
Hope this helps!