How to force month field display 1 till 12 only ?

[admin11]

Month field value label :-

1 till 12 

I use this field at every tab top right Conner 

Some Tab can display 1 till 12 which is fine

But some tab it will display with Blank value label. 

May I know how to force it only display 1 till 12 only. 

Paul

[MattAllington]

Assuming you are using a calendar table, a blank most likely means you have dates in your fact table that doesn't have a match in the calendar table. It is easy to find. Go to a new page, add a table with the date from your fact table. Add a slicer with the date from your calendar table. If there is a blank in the slicer, that confirms the problem.  Click the blank in the slicer to see which dates are missing. 

[admin11]

Hi Matt

Thank you very much for sharing.

So I assume there are 2 approach to get away the Blank value label :-

1) Modify the Month field expression remove the Blank . 
2) Make the raw data no Blank value 

Hope you can advise me 

Paul

[MattAllington]

You can put a filter on blank if you like, but I don't recommend it. It just hides the problem.  I can't tell if there are blanks in your data - you didn't provide enough info. If you have dates in a fact table (actual dates, not blanks) with no matching date in the calendar table, the calendar table will display a blank. 

[admin11]

Hi Matt

Thank you for your sharing. Yes i agree with you using filter is not a good solution , the reason i try to solve it is because when Blank value label pop up , the month field can only display 1 till 7 , as i want to save space. unable to provide long display for month.

Enclosed is my PBI file :-

https://www.dropbox.com/s/ywb5zqf8nnybi4a/PBT_V2021_125%20SOLVE%20BLANK%20IN%20MONTH.pbix?dl=0

[ryan_mayu]

@admin11 

you have blank values in Last sales column of INVC table

The data column of supplier table is also empty.

Please check all the columns that have relationship with date column of calendar table and see if there are emply cells.

I think the best solution for your data is to create a page or report filter and unselect blank.