Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Team,
I have data in the mention below formate. Can you please help me how to transform this data to get the visulisation count by user on date selected from the date slicer .
SAP IDNamesLOBWorking DayMonthly Target 1-Feb-232-Feb-233-Feb-234-Feb-235-Feb-236-Feb-237-Feb-238-Feb-239-Feb-2310-Feb-2311-Feb-2312-Feb-2313-Feb-2314-Feb-2315-Feb-2316-Feb-2317-Feb-23
UCON900030 | Sanjay Thakur | PO Condition | 19 | 2441 | 130 | 120 | 132 | 0 | 0 | 140 | 130 | 130 | 122 | 127 | 0 | 0 | 130 | 130 | 34 | 95 | 130 |
UCON900004 | Garima Lawania | PO Condition | 19 | 2550 | 130 | 120 | 130 | 0 | 0 | 0 | 130 | 130 | 122 | 130 | 0 | 0 | 146 | 130 | 109 | 95 | 130 |
UCON900006 | Kanupriya Chauhan | PO Condition | 18 | 2437 | 130 | 120 | 130 | 0 | 0 | 138 | 0 | 130 | 122 | 130 | 0 | 0 | 130 | 130 | 132 | 120 | 130 |
UCON900035 | Anju Barthwal | PO Condition | 19 | 2534 | 130 | 120 | 130 | 0 | 0 | 138 | 130 | 130 | 0 | 130 | 0 | 0 | 130 | 127 | 103 | 95 | 130 |
UCON900010 | Ankita Kumari | PO Condition | 20 | 2660 | 130 | 120 | 130 | 0 | 0 | 138 | 130 | 130 | 122 | 130 | 0 | 0 | 130 | 130 | 104 | 95 | 130 |
UCON900046 | Anmol Jain | PO Condition | 19 | 2459 | 130 | 0 | 130 | 0 | 0 | 130 | 105 | 130 | 122 | 130 | 0 | 0 | 130 | 130 | 106 | 95 | 130 |
UCON900029 | Shweta Bali | PO Condition | 19 | 2488 | 105 | 75 | 120 | 0 | 0 | 138 | 130 | 130 | 121 | 130 | 0 | 0 | 0 | 130 | 120 | 120 | 127 |
UCON900064 | Shubham Chaudhary | PO Condition | 20 | 2661 | 130 | 120 | 130 | 0 | 0 | 138 | 130 | 130 | 122 | 130 | 0 | 0 | 130 | 130 | 104 | 95 | 130 |
UCON900013 | Shivani Gupta | PO Condition | 17 | 2120 | 130 | 120 | 120 | 0 | 0 | 138 | 130 | 130 | 122 | 130 | 0 | 0 | 0 | 107 | 32 | 95 | 130 |
UCON900049 | Binti Saran | PO Condition | 18 | 2316 | 130 | 120 | 130 | 0 | 0 | 138 | 130 | 130 | 100 | 130 | 0 | 0 | 130 | 113 | 104 | 95 | 130 |
UCON900023 | Amit Kumar Jha | PO Condition | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
UCON900024 | Kishan Kumar | Validation | 18 | 2420 | 130 | 130 | 130 | 0 | 0 | 130 | 130 | 130 | 130 | 130 | 0 | 0 | 130 | 140 | 140 | 130 | 0 |
UCON900043 | Shailesh Jha | Validation | 20 | 2690 | 130 | 130 | 130 | 0 | 0 | 130 | 130 | 130 | 130 | 130 | 0 | 0 | 130 | 140 | 140 | 130 | 130 |
UCON900044 | Jigar Kalra | Validation | 20 | 2630 | 130 | 130 | 130 | 0 | 0 | 130 | 130 | 130 | 130 | 130 | 0 | 0 | 130 | 130 | 130 | 130 | 130 |
UCON900008 | Vinay Sehgal | Validation | 20 | 3350 | 200 | 70 | 80 | 0 | 0 | 210 | 210 | 210 | 210 | 210 | 0 | 0 | 230 | 240 | 240 | 130 | 130 |
UCON900039 | Shweta Yadav | Validation | 20 | 2630 | 130 | 130 | 130 | 0 | 0 | 130 | 130 | 130 | 130 | 130 | 0 | 0 | 130 | 130 | 130 | 130 | 130 |
UCON900040 | Monika | Validation | 20 | 2630 | 130 | 130 | 130 | 0 | 0 | 130 | 130 | 130 | 130 | 130 | 0 | 0 | 130 | 130 | 130 | 130 | 130 |
UCON900037 | Mansi Reswal | Validation | 14 | 1850 | 130 | 130 | 130 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 130 | 130 | 130 | 130 | 130 |
UCON900038 | Raghvendra Mishra | Validation | 13 | 1690 | 130 | 130 | 130 | 0 | 0 | 130 | 130 | 130 | 0 | 0 | 0 | 0 | 130 | 140 | 140 | 130 | 130 |
UCON900050 | Basram Choudhary | Validation | 20 | 2620 | 130 | 130 | 130 | 0 | 0 | 130 | 130 | 130 | 130 | 130 | 0 | 0 | 130 | 140 | 140 | 130 | 130 |
UCON900003 | Bipin Rai | Validation | 17 | 2250 | 130 | 130 | 130 | 0 | 0 | 130 | 130 | 130 | 130 | 130 | 0 | 0 | 130 | 140 | 140 | 130 | 130 |
UCON900059 | Aman Soni | Validation | 20 | 2630 | 130 | 130 | 130 | 0 | 0 | 130 | 130 | 130 | 130 | 130 | 0 | 0 | 130 | 130 | 130 | 130 | 130 |
UCON900051 | Kumar Gyan Vardhan | Validation | 18 | 2210 | 120 | 120 | 120 | 0 | 0 | 120 | 120 | 120 | 120 | 120 | 0 | 0 | 120 | 120 | 120 | 130 | 120 |
UCON900063 | Naveen Gupt | Validation | 8 | 1050 | 130 | 130 | 130 | 0 | 0 | 130 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
UCON900034 | Amritesh Mishra | Validation | 17 | 2240 | 130 | 130 | 130 | 0 | 0 | 130 | 130 | 130 | 130 | 130 | 0 | 0 | 130 | 130 | 130 | 0 | 0 |
UCON900025 | Abul Shoaib | Validation | 1 | 130 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 130 | 0 |
UCON900065 | Ashok Singh | Validation | 8 | 840 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 100 | 100 |
UCON900048 | Varun Gupta | VIM Exception | 15 | 1635 | 128 | 147 | 148 | 0 | 0 | 135 | 100 | 98 | 86 | 110 | 0 | 0 | 0 | 17 | 130 | 130 | 110 |
UCON900031 | Shivam Gupta | VIM Exception | 19 | 2679 | 130 | 140 | 140 | 0 | 0 | 138 | 140 | 131 | 116 | 103 | 0 | 0 | 0 | 40 | 150 | 140 | 140 |
UCON900045 | Neetu Rawat | VIM Exception | 20 | 2663 | 133 | 141 | 138 | 0 | 0 | 157 | 134 | 130 | 120 | 133 | 0 | 0 | 6 | 41 | 143 | 140 | 158 |
UCON900042 | Komal Rawat | VIM Exception | 19 | 2439 | 128 | 142 | 148 | 0 | 0 | 152 | 138 | 130 | 123 | 135 | 0 | 0 | 5 | 51 | 144 | 140 | 140 |
UCON900033 | Jitesh Tandon | VIM Exception | 19 | 2460 | 141 | 151 | 140 | 0 | 0 | 211 | 128 | 133 | 102 | 101 | 0 | 0 | 10 | 28 | 142 | 140 | 140 |
UCON900041 | Ayush Garg | VIM Exception | 15 | 1587 | 142 | 131 | 140 | 0 | 0 | 203 | 100 | 76 | 103 | 0 | 0 | 0 | 8 | 9 | 134 | 134 | 110 |
UCON900007 | Shivani Choudhary | VIM Exception | 16 | 1784 | 138 | 121 | 141 | 0 | 0 | 141 | 102 | 100 | 82 | 101 | 0 | 0 | 86 | 44 | 130 | 139 | 110 |
UCON900032 | Disha Satija | VIM Exception | 19 | 2405 | 130 | 140 | 140 | 0 | 0 | 136 | 130 | 124 | 130 | 130 | 0 | 0 | 27 | 15 | 140 | 140 | 0 |
UCON900061 | Rishabh Srivastava | VIM Exception | 16 | 1989 | 122 | 142 | 142 | 0 | 0 | 146 | 117 | 130 | 130 | 130 | 0 | 0 | 18 | 36 | 148 | 139 | 140 |
UCON900036 | Nancy Garg | VIM Exception | 19 | 2689 | 146 | 149 | 144 | 0 | 0 | 146 | 148 | 143 | 134 | 137 | 0 | 0 | 0 | 18 | 151 | 140 | 140 |
UCON900005 | Shubham Sagar | VIM Exception | 20 | 2703 | 140 | 125 | 140 | 0 | 0 | 140 | 113 | 121 | 131 | 120 | 0 | 0 | 10 | 50 | 129 | 149 | 140 |
UCON900015 | Neha Kumari | VIM Exception | 16 | 2003 | 132 | 168 | 128 | 0 | 0 | 128 | 126 | 129 | 124 | 51 | 0 | 0 | 0 | 3 | 149 | 139 | 140 |
UCON900066 | Ankit Kothari | VIM Exception | 12 | 1515 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14 | 20 | 154 | 140 | 145 |
UCON900009 | Kanika Sharma | VIM Exception | 14 | 1846 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 70 | 121 | 107 | 0 | 0 | 0 | 40 | 145 | 140 | 140 |
UCON900052 | Mamta Rawat | VIM Exception | 8 | 949 | 130 | 142 | 140 | 0 | 0 | 136 | 87 | 129 | 107 | 78 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
UCON900062 | Puja Gupta | VIM Exception | 18 | 2318 | 133 | 0 | 124 | 0 | 0 | 133 | 112 | 130 | 120 | 126 | 0 | 0 | 0 | 11 | 140 | 140 | 140 |
Hi @KuntalSingh,
You can do unpivot columns on these date fields, then you can simply use unpivoted date values as source of slicer to filter and summary table records:
Unpivot columns - Power Query | Microsoft Learn
Regards,
Xiaoxin Sheng
Hi Xiaoxin,
Thanks for your kind support.
I treid this but it throws an error of duplicate records and due to this I am not able to save the changes
Hi @KuntalSingh,
It seems like the unpivot column operation change the table structure and it affect the table relationship analysis.
Perhaps you can duplicate the table to create a copy for these operations and visual designs, this new table should not affect the raw table relationship mappings.
Regards,
Xiaoxin Sheng