Forum Discussion
Data view error in Slicer
Hi, Larry_Wang
Have you enabled time intelligence? If you enable Time intelligence, it will create a hierarchy for the calendar year. So you will get all months of this calendar year in this Date Hierarchy and every month will be listed in the Slicer. If you want to remove months except January. You can Exclude other months.
Select those months and Exclude them.
Then, only January will be listed in the Slicer. The result looks like this:
For more details about Time intelligence, you can refer Automatic time intelligence in Power BI.
Best Regards,
Caiyun Zheng
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
As I've mentioned in my first reply. After enabling Time intelligence, it will create a date hierarchy(Year, Quarter, Month, Day) for the entire calendar year(such as 2021). So you will get all months of this calendar year in Month and every month will be listed in the Slicer. If you want to remove months except January. You can try to Exclude other months.
Best Regards,
Caiyun Zheng