Donut and clustered bar charts aggregate data based on a date range selected in date slicers

[Lexignot]

Hello,

In the attached dashboard (link) I'd like to have my donut and clustered bar charts to display the total of IDs by type of Media for a given Period selected: the charts should update dynamically when I change the Periods or select a custom date range. At the moment, the charts display the number of IDs (i.e. count of IDs) per day, they do not aggregate the number of IDs by type of Media (see below illustrations).

Do you know how I can achieve this?

Thanks in advance for your help!

Donut chart:

Current result for the Last 7 days: 

Expected result:

Clustered bar chart:

Current result for the Last 7 days: 

Expected result:

[Lexignot · Accepted solution]

Hi @K0da thnak you for your message. Yes, I removed the Date in the legend and used a relative date slicer so that I only have one slicer. This way, I can get the relative date ranges I need, and the charts update properly.

Thanks!

[K0da]

Hi,

from what i've seen, just remove the "date" variable from the visual

They should aggregate now, and be filtered by the date period selected on the slicer, l also noticed the "Date" slicer is being filtered by "Period_Selection" this is limiting the dates that can be selected, but maybe it's supposed to be like that.