Using a slicer of date hierarchy to select the input on a graph using parameters

[Anonymous]

Hi, 

I got the answer on how to make a slicer using the date hierarchy https://community.fabric.microsoft.com/t5/Desktop/Using-a-slicer-of-date-hierarchy-to-select-the-inp..., however, after that I still have to link it to my date dimension table, because if I select Day, it then shows the data per daynumber, but I would also like to select the month, the day is in. Could anyone help me? So that it not only shows the 14th for example, but I can specify the 14th of December 2023.

Thank you

Luuk

[Idrissshatila]

Hello @Anonymous ,

why don't you create a hirarchy in your dimension table and then group them by in a field parameter, in this case you couls use all the fields.

[Anonymous]

Hello @Idrissshatila,

Currently in my dimension table there is a date hierarchy, however if I try to make a relationship between those two, it does not work. 

Right now I have set it up as the screenshot shows, but this doesn't work.

dwh_dim_date is the original dimension table of with dates, the Date table contains the parameter logic using the previous post. What is the best way to link those two together?

Right now I tried it using the values from dwh_dim_date and then the dates which contain a date hierarchy, so pk_date is on day level, month is on month level, year is on year level. Then I assigned these to the dwh_dim_date_slicer. Then I linked this to dimension where dimension = dimension and this is year to year, month to month, day to day.

Then I linked this one to Date on dimension to datum.

This does not work as of now.