Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
99 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
106 | |
105 | |
86 | |
72 |