Forum Discussion

Larry_Wang's avatar
Larry_Wang
Helper I
5 years ago
Solved

Data view error in Slicer

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

Need Help
  • v-cazheng-msft's avatar
    v-cazheng-msft
    5 years ago

    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.

     

12 Replies

    • Larry_Wang's avatar
      Larry_Wang
      Helper I
      5 years ago

      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's avatar
        amitchandak
        Super User
        5 years ago

        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.

  • v-cazheng-msft's avatar
    v-cazheng-msft
    Community Support
    5 years ago

    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's avatar
      Larry_Wang
      Helper I
      5 years ago

      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's avatar
        v-cazheng-msft
        Community Support
        5 years ago

        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