Forum Discussion

Cke's avatar
Cke
Regular Visitor
6 months ago
Solved

Order Date function not on display in View Table (Power BI)

Hi there,

I am looking for some help please šŸ™‚

 

I am trying to use the function Order Date in Power BI (View Table mode). However it does not appear after creating a new column. I am attaching a photo (from a Youtube video) of what I am trying to get vs a photo of what my View Table mode really displays.

 

Image 1. What I need to get

 

Image 2. What my View Table displays

 

In my power BI I cannot see all the functions displayed in the Youtube video despite I am texting the function similarly.

What I can do to get the functions on display in the video?

 

Note: the link for the Youtube video I am trying to imitate is: https://www.youtube.com/watch?v=L4z-sZvUDFU

 

Thank you in advance  šŸ™‚

Need Help
  • Natarajan_M's avatar
    Natarajan_M
    6 months ago



     

    Hi Cke ,

    Month is the function order date is the column in the table used in the video .

    to get the month number you need to use the 

    Month = month(financials[Date])
     

    make sure the Date is in the correct date datatype 

    https://learn.microsoft.com/en-us/dax/month-function-dax


    Thanks 

     

    If this response was helpful in any way, Iā€™d gladly accept a kudo.
    Please mark it as the correct solution. It helps other community members find their way faster.

     

  • Natarajan_M's avatar
    Natarajan_M
    6 months ago

    Hi Cke  can you use the sort by columns option. 

     

    Select the column thats used in the button slicer then sort by month. Number this should resolve the sorting issue 

10 Replies

  • MFelix's avatar
    MFelix
    Super User
    6 months ago

    Hi Cke ,

     

    The Order Date is not a function is a column on the orders table.

     

    If you do not have that table and that column you want BE able to see the column.

  • Natarajan_M's avatar
    Natarajan_M
    Super User
    6 months ago



     

    Hi Cke ,

    Month is the function order date is the column in the table used in the video .

    to get the month number you need to use the 

    Month = month(financials[Date])
     

    make sure the Date is in the correct date datatype 

    https://learn.microsoft.com/en-us/dax/month-function-dax


    Thanks 

     

    If this response was helpful in any way, Iā€™d gladly accept a kudo.
    Please mark it as the correct solution. It helps other community members find their way faster.

     

    • Cke's avatar
      Cke
      Regular Visitor
      6 months ago

      Thank you so much Natarajan_M :).

       

      I have another question related, please: 

       

      I am using a button slicer to filter or control the bar chart you can see in the picture. However, the date format includes the full date (day/month/year). There is any method for the name of the month to appear instead of the full date, just as in the bar graph?

       

      Thank you so much in advance

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        6 months ago

        Hi,

        Create this calculated column in the Calendar table

        Month name = format(calendar[date],"mmmm")