Grouping data by dates

[Syndicate_Admin]

Good!

I have created a line graph in which on the horizontal axis you have the time and on the vertical axis a measurement.

I want to create a filter that is similar to the one in the following image:

In which, the option to group by date if I select "By months" shows me the data grouped by months, if I select "By days" I do it by days and if I select by years I do it by years. That is, the horizontal axis of my graph varies automatically according to the selection I make in the second filter.

Thank you!

[Anonymous · Accepted solution]

Hi @Syndicate_Admin ,
According to your description, you can create a column corresponding to the year, month, and day based on your date, and then use the year, month, and day columns to create a filed parameter and put this parameter into the x-axis of the line graph, as follows
Create day, month,year column

DAY = DAY('Table'[Date])

MONTH = MONTH('Table'[Date])

YEAR = YEAR('Table'[Date])

Use these columns as filed parameter value

Use parameter as x-axis

Final output

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Anonymous]

@Syndicate_Admin can u help me pls. I posted something about expanding tables and my questions is not good formulated. Can you look over it?