Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

How to remove day Wednesday from the month year?

I want the field to only show month and year, don't want the days like Wednesday or Saturday. How do I do it? 

Thanks

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous ,

    Base on your screenshot, it seems what you are creating is a slicer using the date field. If you only want to display the data as year month, you can select the date field which applied on the slicer and set the proper date format as below screenshot.

    Best Regards

3 Replies

  • dharmendars007's avatar
    dharmendars007
    Icon for Memorable Member rankMemorable Member
    1 year ago

    Hello Anonymous , 

     

    You can create a calculated column like below in your date table or where date is present, this will formt the date to only Month and year

     

    MonthYear = FORMAT([YourDateColumn], "MMMM yyyy")

     

    If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!

     

    Thank You

    Dharmendar S

    LinkedIN 

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi, do u mean create in the excel or powerbi? If powerbi, how do I do that? I am new to powerbi and have not much idea how powerbi work.

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi Anonymous ,

        Base on your screenshot, it seems what you are creating is a slicer using the date field. If you only want to display the data as year month, you can select the date field which applied on the slicer and set the proper date format as below screenshot.

        Best Regards