Line graph should display default values

[Anshenterprices]

Hello Team,

Source Data

Category	Sub Category	Last day	last month	MTD	Date	CDate	Type
Commodity	T1	19.43	-0.75	0.75	9/29/2021	29-Sep-21	Broker
FNO	MF1	0.5	7.82	19.45	9/29/2021	29-Sep-21	Broker
FNO	B1	3.95	4	0.5	9/29/2021	29-Sep-21	Broker
FNO	c1	0.47	31.36	3.94	9/29/2021	29-Sep-21	Broker
Equity	ash1	7	19.69	1.22	9/29/2021	29-Sep-21	Broker
Equity	ab1	4	0.51	-0.75	9/29/2021	29-Sep-21	Broker
Equity	te1	31.41	3.96	7.78	9/29/2021	29-Sep-21	Broker
FNO	s1	0.75	0.54	3.99	9/29/2021	29-Sep-21	Broker
Commodity	T1	19.45	-3.01	31.41	9/30/2021	30-Sep-21	Broker
FNO	MF1	0.5	7.77	0	9/30/2021	30-Sep-21	Broker
FNO	B1	3.94	1.99	7.82	9/30/2021	30-Sep-21	Broker
FNO	c1	1.22	34.39	4	9/30/2021	30-Sep-21	Broker
FNO	U1	-0.75	3.04	31.36	9/30/2021	30-Sep-21	Broker
Equity	ash1	7.78	19.45	19.69	9/30/2021	30-Sep-21	Broker
Equity	ab1	3.99	0.51	0.51	9/30/2021	30-Sep-21	Broker
Equity	te1	31.41	3.98	3.96	9/30/2021	30-Sep-21	Broker
FNO	s1	0	0.72	0.54	9/30/2021	30-Sep-21	Broker
Commodity	T1	19.65	-3.01	-3.01	10/1/2021	1-Oct-21	Broker
FNO	MF1	0.51	0.75	7.77	10/1/2021	1-Oct-21	Broker
FNO	B1	3.98	19.45	1.99	10/1/2021	1-Oct-21	Broker
FNO	c1	1.2	0.5	34.39	10/1/2021	1-Oct-21	Broker
FNO	U1	-0.75	3.94	3.04	10/1/2021	1-Oct-21	Broker
Equity	ash1	7.82	1.22	19.45	10/1/2021	1-Oct-21	Broker
Equity	ab1	4	3.96	0.51	10/1/2021	1-Oct-21	Broker
Equity	te1	31.36	0.54	3.98	10/1/2021	1-Oct-21	Broker
Commodity	T1	19.69	-3.01	0.72	10/4/2021	4-Oct-21	Broker
FNO	MF1	0.51	7.77	-3.01	10/4/2021	4-Oct-21	Broker
FNO	B1	3.96	1.99	0.54	10/4/2021	4-Oct-21	Broker
FNO	c1	0.54	34.39	-3.01	10/4/2021	4-Oct-21	Broker
FNO	U1	-3.01	3.04	7.77	10/4/2021	4-Oct-21	Broker
Equity	ash1	7.77	19.45	1.99	10/4/2021	4-Oct-21	Broker
Equity	ab1	1.99	0.51	-3.01	10/4/2021	4-Oct-21	Broker
Equity	te1	34.39	3.98	7.71	10/4/2021	4-Oct-21	Broker
FNO	s1	3.04	0.72	1.99	10/4/2021	4-Oct-21	Broker
Commodity	T1	19.45	-3.01	34.49	10/5/2021	5-Oct-21	Broker
FNO	MF1	0.51	-3.01	3.02	10/5/2021	5-Oct-21	Broker
FNO	B1	3.98	0.75	0.0408	10/5/2021	5-Oct-21	Broker
FNO	c1	0.72	19.45	0.72	10/5/2021	5-Oct-21	Broker
FNO	U1	-3.01	0.5	-3.01	10/5/2021	5-Oct-21	Broker
Equity	ash1	7.71	3.94	7.71	10/5/2021	5-Oct-21	Broker
Equity	ab1	1.99	1.22	1.99	10/5/2021	5-Oct-21	Broker
Equity	te1	34.49	3.96	34.49	10/5/2021	5-Oct-21	Broker
FNO	s1	3.02	0.54	3.02	10/5/2021	5-Oct-21	Broker
Equity	ab1	0.0408	-3.01	0.0408	9/29/2021	29-Sep-21	Online
Equity	ab1	0.0208	7.77	0.0208	10/1/2021	1-Oct-21	Online
Equity	ash1	0.0752	1.99	0.0752	9/29/2021	29-Sep-21	Online
Equity	ash1	0.0752	-3.01	0.0752	10/1/2021	1-Oct-21	Online
Equity	te1	0.3317	7.71	3.96	9/29/2021	29-Sep-21	Online
Equity	te1	0.3617	1.99	0.54	10/1/2021	1-Oct-21	Online
Commodity	T1	0.1992	34.49	-3.01	9/29/2021	29-Sep-21	Online
Commodity	T1	0.1992	3.02	7.77	10/1/2021	1-Oct-21	Online
FNO	B1	0.0284	0.0408	1.99	9/29/2021	29-Sep-21	Online
FNO	B1	0.0284	0.3617	-3.01	10/1/2021	1-Oct-21	Online
FNO	MF1	0.005	0.1992	7.71	9/29/2021	29-Sep-21	Online
FNO	MF1	0.005	0.1992	34.49	10/1/2021	1-Oct-21	Online

Requirement:- 
I have Horizontal Category slicer on top of the page and then Sub category dropdown slicer 
and i have created 1 custom table lastday,lastmonth, mtd and same use as horizontal Slicer

and the botoom of page line graph- Xaxis date and y axis values- based on the selection of last day , last moth and mtd slicer

but the problem is when its selected all on subcatergory then it should display MF1 By default in line graph and last day values.

because when user wants to select other category then he should select all from subcategory and then select category that time there are so many subcategory comes in the line graph there are more than 100 sub category thats why default line graph should be MFA and last day values by date

Thanks

[v-henryk-mstf]

Hi @Anshenterprices ,

I've done tests and I can't seem to reproduce your problem. Can you provide a screenshot of the corresponding operation, and the desired result. It is convenient for me to answer your question.

Looking forward to your reply.

Best Regards,
Henry