Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |