Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

Field Parameters with Dates

Hello everyone

I was practicing the use of field parameters. I've currently tried to create a field parameter using two date fields, but when I enter that parameter to the x-axis of a line chart, I lose the hierarchy that a date field has (months, years, quarter, etc). You can use the date field parameters and maintain hierarchies, or you need to do something more complex to achieve this

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    2 years ago

    Syndicate_Admin , Ideally do not prefer to use date hierarchy, I will create additional columns in the date table and  use that

     

    But you can drag each hierarchy element 

    Date Hi = {
    ("Year", NAMEOF('Sales'[Deilvery Date].[Year]), 0),
    ("Quarter", NAMEOF('Sales'[Deilvery Date].[Quarter]), 1),
    ("Month", NAMEOF('Sales'[Deilvery Date].[Month]), 2),
    ("Day", NAMEOF('Sales'[Deilvery Date].[Day]), 3)
}