Remove/Don't show the months with no data in Column, though "Show item with now data" is unchecked"?

[sspk]

HI,

I have a slicer with Tile and using a column "events_date' with Date Type. Also Show items with no data is "unchecked.

Ex: This is Aug,2024 month and it shows for SEP,OCT,NOV,DEC.

How to restrict it not showing feature months based on the table column? or some other way?

Thanks in advance,

Siva

[Ashish_Mathur]

Hi,

One simple way is to ensure that the Calendar table only goes uptil the last date in the Date column of the Fact Table.  Drag Year and Month name from the Calendar Table.

[ssspk]

HI @Ashish_Mathur 

Thank you for your reply.

Hi @v-yohua-msft ,

Thank you for your reply and time,

I can achieve it by add ing therese sprate measures in different columns,

Day = FORMAT('Table_Name'[event_date], "DD")

MonthName = FORMAT(Table_Name[event_date], "MMMM")

Year = FORMAT('Table_Name'[event_date], "YYYY"),

MonthNumber = MONTH('Table_Name'[event_date]) -- (Which is used for Sorting of the columns of MonthName.)

Now how to make the current month as default selected like "August" in Tile Month, When page loads?

 Thanks ,

Siva

[v-yohua-msft]

Hi, @sspk 

Maybe you can create a calculated column to achieve what you want.

I create a sample table:

Then create a calculated column and try the following dax:

Month = MONTH('Table'[Date]) 

Here is my preview:

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ssspk]

Hi @v-yohua-msft ,

Thank you for your reply and time,

I can achieve it by add ing therese sprate measures in different columns,

Day = FORMAT('Table_Name'[event_date], "DD")

MonthName = FORMAT(Table_Name[event_date], "MMMM")

Year = FORMAT('Table_Name'[event_date], "YYYY"),

MonthNumber = MONTH('Table_Name'[event_date]) -- (Which is used for Sorting of the columns of MonthName.)

Now how to make the current month as default selected like "August" in Tile Month, When page loads?

 Thanks ,

Siva

[v-yohua-msft · Accepted solution]

Hi, @ssspk 

Maybe you can use bookmark. You can learn more about this.

Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Learn

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.