How to show a multi-day line chart inside a filtered by day page

[Tallone]

I have a page of visualizations all linked to a single day via a slicer. I would now like to grab the month out of the date and show a line chart with values for each day.

Basically all the visualizations on the sheet are a combination of grids, bar charts, and tables that reflect data from a single day or totalled to a date.

This new visualisation is intended to show each day from the selected month as a point in a line chart. Actual and target values will each have a line.

Does anyone know how to do this?

[v-qiuyu-msft]

Hi @Tallone,

It seems that there is a slicer in the report page to filter all visuals, and you want to get the month value from the selected date in slicer, then return actual and target line values in a line chart for each day in this month, right?

In your scenario, you can add another slicer which contains the month value, then you set this new slicer only filter the line chart use Edit Interactions. See:

Best Regards,
Qiuyun Yu

[Tallone]

Thank you for your input. I see what you are trying to do. Do I need a separate field in my data for month, or can I program the 2nd slicer to pick the month of the first slicer's date?

[v-qiuyu-msft · Accepted solution]

Hi @Tallone,

As the original slicer can filter this new slicer, I would suggest you create a calculated column to return month value:

Month = Month('Table1'[Date])

You can take a look at attached .PBIX file in my original post.

Best Regards,
Qiuyun Yu

[Tallone]

Thank you!

It would be nice if this could be a "hidden slicer" that performed the function but was not seen, but I can work with this as is.

Mark