Filter legends with slicer

[Anonymous]

I want to see each month on the x-axis when I filter lines on the graph using a slicer. The problem is that the data on the graph is continuous and I can't filter out categories with continuous data.

The only way I have been able to filter out each category is by formatting each month as continuous data and using that as the legend. It works, but it doesn't look right. I want to be able to use the slicer on the left with the graph on the right.

[TeigeGao]

Hi @Anonymous ,

>>I can't filter out categories with continuous data.

In this scenario, we can create another continuous data table and map to this table.

Best Regards,

Teige

[Anonymous]

Do you mean create another continuous data table based on month and create a relationship between those two tables? What kind of relationship?

[TeigeGao · Accepted solution]

Yes, we can use CALENDARAUTO() function, the kind of relationship depends on your scenario, if it is one-to-many, then use one-to-many relationship, if it is many-to-many, then use many-to-many relationship.