Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
BI_Power_Guy
Frequent Visitor

Date showing all months in slicers and tables visual , even if i am analyzing 3 months of data

Hi Team,

 

today i have observed a strange behaviour where i am getting all months of an year in slicer , even when i am having 3 months of data in PBIX .Below is snippets.Let me know if this is a bug or not.

 

I have tried to search community blogs , but didn't find anything.

(EARLIER THIS WAS NOT AN ISSUE)

 

I also wanted to highlight , that creating a measure like YEAR(date_field), MONTH(Date_field) is not possible now and i have to created calculated column .

 

Thanks 

 

BI_Power_Guy_0-1652124191161.pngBI_Power_Guy_1-1652124226749.png

 

1 ACCEPTED SOLUTION
v-cgao-msft
Community Support
Community Support

Hi @BI_Power_Guy ,

 

Did my answer help you? If any post is helpful, please consider accepting it as a solution to help other members find it faster. Thank you very much!

 

Sincerely,

Gao
Community Support Team

View solution in original post

9 REPLIES 9
v-cgao-msft
Community Support
Community Support

Hi @BI_Power_Guy ,

 

Did my answer help you? If any post is helpful, please consider accepting it as a solution to help other members find it faster. Thank you very much!

 

Sincerely,

Gao
Community Support Team

BI_Power_Guy
Frequent Visitor

Hi @Ashish_Mathur @v-cgao-msft @lbendlin @amitchandak  ,

 

attached is the sheet link, page1 is having date slicer , there are 3 months in my data, slicers showing all 12 months of year.

 

https://1drv.ms/u/s!Ai39eZshVz3dhG0wLOJY4sTDe3JC?e=ahXPPR

Hi @BI_Power_Guy ,

 

The field source for the slicer is the date hierarchy under 'Date Dim' table, and as mentioned above, it will automatically create all the dates under the complete date year.

vcgaomsft_1-1653270879950.png

You can use [Year] and [Month] under the date table as fields for the filter.

vcgaomsft_0-1653270608873.png

Some minor modifications need to be made to the calculated columns under the date table, and the PBIX file is attached for reference.

 

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

Hi,

This is because the slicer is based on a Date hierarchy.  Instead, create 2 slicers - one from the year column another from the Month column in your Date Table.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Ashish_Mathur
Super User
Super User

Hi,

Share the download link of your PBI file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
BI_Power_Guy
Frequent Visitor

v-cgao-msft
Community Support
Community Support

Hi @BI_Power_Guy ,

 

Please check if the fields in the slicer are from the month under Date Hierarchy.

vcgaomsft_0-1652332159449.png

vcgaomsft_1-1652332186691.png

The auto date/time table contains full calendar years encompassing all date values stored in the model date column.

Auto date/time in Power BI Desktop

 

You can disable this function here.

vcgaomsft_2-1652332375072.png

Attached PBIX file for reference.

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

Hi @v-cgao-msft @lbendlin ,

 

Even after disabling auto date/time in time intelligence and show items with no data is already not selected , all momths are coming in date slicers , (months are coming from date hiearchy model).

 

Let me know any way to procceed as it is quite irritating , earlier from date hiearchy ..there was no issue like this.

lbendlin
Super User
Super User

Validate if you (maybe inadvertently) enabled "show items with no data".

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors