Data view error in Slicer

[Larry_Wang]

Hi Every one,

Happy new year!

I am using a Slicer in my report but there is something wrong with it. It seems that slicer is using Day value for Month value. See picture below for details. Actually all data is for January but in slicer it is wrong.

     

I already set the data format to d/m/yyyy. See picture below for details. Can any one know how to solve this issue?

Thanks,

Larry

[v-cazheng-msft · Accepted solution]

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.

[Larry_Wang]

Hi @v-cazheng-msft ,

I enabled time intelligence and the problem is all the date is for January, there is no date for other months. But the Slicer identifies 11/1/2021 as November. I don't know how to let Slicer use "1" as month, not use "11".

Thanks,

Larry

[v-cazheng-msft]

Hi, @Larry_Wang 

You can try to regulate the way of identifying date type data by the following steps in Power Query Editor. Then you can set date format to “mmmm d, yyyy” to check it.

Best Regards,

Caiyun Zheng

[Larry_Wang]

Hi @v-cazheng-msft ,

I tried to set the date format in Query Editor as what you showed in your last reply, and it still doesn't work. I also tried to change the Date&Time settings on my computer, it has no help to solve this issue.

[v-cazheng-msft]

@Larry_Wang 

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

[Larry_Wang]

Hi @v-cazheng-msft ,

Thanks for the help on this issue. It works now for me. 

Have a nice day!

Larry

[amitchandak]

@Larry_Wang , Right click on the field in visual pane and choose Date.

[Larry_Wang]

Hi @amitchandak ,

Thank you for your reply on this. I tried that but still the same. My data format is like 12/2/2021 but when using slicer it is using number 12 as month value. Really strange and I also tried to change my system settings for data & time, but can not solve the issue.

[amitchandak]

@Larry_Wang ,have you cross (when the hierarchy was showing) Year, Qtr, Day in the date in Visual pane.

Can you share some screenshots.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Larry_Wang]

Hi @amitchandak ,

I tried to upload a test data but it seems it is not  supported to upload csv and power bi file here😂

[amitchandak]

@Larry_Wang , you can copy paste from excel or power BI.

Or upload file on dropbox or one driver and share link

[Larry_Wang]

Hi @amitchandak ,

unfortunately I can only upload a picture of the data source here

In the bar chart everything is ok (Only January), but in the slicer we can see many other month names listed.