How to load different period data in different visuals as default?

[vicky1610]

Hi guys,

I am wondering how can we load a different period data in different visuals inside the report?

ex. I have data for last 360 days. and I am using 4 different visuals.

When the report loads I want to show,

visual 1 -> last 30 days data

visual 2 -> last 90 days data

visual 3 -> last 180 days data

visual 4 -> last 360 days data

catch is I am using single relative date slicer for all visuals, if slicer is selected all visuals should show that range data, else it should show default data as above.

I have tried it using filters to load data, it works well when I selected less range of days(30 days or less) as for visual 1 the cap gets set to 30 days max. I want it to be dynamic upto 360 days or whatever the range selected in slicer.

Can anyone help?

Note: I dont want to show dates in any visual, just corresponding data.

Sample data:

Date	value	Category	Label	Count
17-May-24	1	AX	a1	2
16-May-24	2	BX	a2	3
15-May-24	3	CX	a3	5
14-May-24	4	DX	a4	3
13-May-24	5	AX	a5	2
12-May-24	6	BX	a6	3
11-May-24	7	CX	a7	5
10-May-24	8	DX	a8	3
09-May-24	9	AX	a9	4
08-May-24	10	BX	a10	4
07-May-24	11	CX	a11	4
06-May-24	12	DX	a12	4
05-May-24	13	AX	a13	4
04-May-24	14	BX	a14	4
03-May-24	15	CX	a15	5
02-May-24	16	DX	a16	5
01-May-24	17	AX	a17	5
30-Apr-24	18	BX	a18	5
29-Apr-24	19	CX	a19	5
28-Apr-24	20	DX	a20	5
27-Apr-24	21	AX	a21	5
....	....	....	....	....

[Anonymous]

Hi @vicky1610 ,

Thank you for @lbendlin  answer , and I have other suggestions:

Below is the sample table:

Try to use filters to load data:

Checking Include Today below will filter out dates up to 30 days from today.Ditto for 90 and 180 and 360.

The final output is shown in the following figure:

Best Regards,

Xianda Tang

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

[vicky1610]

Hi @Anonymous Thank you for your response.

The default data will be 30days, 90days, 180days resp. for visuals when slicer is not selected.

If the date slicer is selected with any interval, all the visuals should show that selected interval data.

Ex. If past 1 year selected, all visuals should show 1 years data

[lbendlin]

There is no need to use slicers.  Use the Filter pane.  If the visuals need different intervals then you need to use visual level filters.

[vicky1610]

Hi @lbendlin 

Thank you for your response.

The default data will be 30days, 90days, 180days resp. for visuals when slicer is not selected.

If the date slicer is selected with any interval, all the visuals should show that selected interval data.

Ex. If past 1 year selected, all visuals should show 1 years data