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

October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more

Reply
Anonymous
Not applicable

Year Filter

I have a date/time field in my data that has been formatted with the data type of Date/Time. 

start.PNG

In the data when I got to put a filter pane on the report, it shows 2019 twice..

 

2019.PNG

Is there any reason why it would do this? Or how to get rid of it?

1 ACCEPTED SOLUTION
TeigeGao
Solution Sage
Solution Sage

Hi @Anonymous ,

This problem occurs because it puts the Date Hierarchy to the slicer field automatically, we can change it to the original column like below: 

v0CuPnfSIb.gif

The result will like below: 

PBIDesktop_poWpkBgJxj.png

Best Regards,

Teige

View solution in original post

1 REPLY 1
TeigeGao
Solution Sage
Solution Sage

Hi @Anonymous ,

This problem occurs because it puts the Date Hierarchy to the slicer field automatically, we can change it to the original column like below: 

v0CuPnfSIb.gif

The result will like below: 

PBIDesktop_poWpkBgJxj.png

Best Regards,

Teige

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.