Month name not coming up in the slicer

[shubham19171996]

Hi, I have 2 slicers one of year and one of month and both have been made from production date. and there are 2 months in which there is not data so no production date as well. so the month slicer does not show the name of the month. I know there is no data which is why it is not showing. But I want the slicer to show the month name even if there is no data.

[Greg_Deckler]

@shubham19171996 You will need another table that has your month names in it and use that as your slicer. This is most often a date table that you then create a relationship to your fact table.