Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Dear Team,
here is the scenario,
i need to show only records which contails the values from filter.
if i select 30Y01AB, I Should get four records.
Regards,
Narender.
Solved! Go to Solution.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
I don't understand what the difference is, the principle is the same
1) you must create a table for the slicer, it is not connected to the main table
2) write down the measure and that's it
Contains in Column 2.pbix
Hi Ahmedx,
Thanks for your efforts. Your solution is workign absolutly fine but there are 2 observations in "Contains in Column2 PBIX". Please address the obseravtions.
1. With no selection in Filter why am seeing 30Y2032 ?
2. With no selection i should see all the records in visual table( Table[Id product])
Regards,
Narender.
superb Man.. thanks for quick respose.
Hi ahmed,
here is the full scenario.
below is the source data.
S.no | Part number Previous | Part number Current | Concatenate | Change Date | Type of change | Part Status | Prev Wei FSC | Curr Wei FSC | Prev Tar FSC | Curr Tar FSC | Qty Prev | Qty Curr |
1 | 30Y0140 | 30Y0140,30Y01XY,30Y0160,30Y0ABC | 05-01-23 | New cost item | New part | 10 | 10 | 15 | 17 | 1 | 1 | |
2 | 30Y0140 | 30Y01XY | 30Y0140,30Y01XY,30Y0160,30Y0ABC | 06-01-23 | Part Replacement | Part Change | 10 | 10 | 15 | 17 | 1 | 1 |
3 | 30Y01XY | 30Y0160 | 30Y0140,30Y01XY,30Y0160,30Y0ABC | 07-01-23 | Part Replacement | Part Change | 10 | 10 | 15 | 17 | 1 | 1 |
4 | 30Y0160 | 30Y0ABC | 30Y0140,30Y01XY,30Y0160,30Y0ABC | 08-01-23 | Part Replacement | Part Change | 10 | 20 | 12 | 18 | 1 | 1 |
5 | 30Y1534 | 30Y1534 | 11-01-23 | New cost item | New part | 10 | 10 | 15 | 13 | 1 | 1 | |
6 | 30Y1532 | 30Y1532 | 12-01-23 | New cost item | New part | 10 | 10 | 15 | 13 | 1 | 1 | |
7 | 30Y0989 | 30Y0989/30Y0100 | 13-01-23 | New cost item | New part | 10 | 10 | 15 | 13 | 1 | 1 | |
8 | 30Y0989 | 30Y0100 | 30Y0989/30Y0100 | 14-01-23 | Part Replacement | Part Change | 10 | 10 | 15 | 13 | 1 | 1 |
below table should genearte on basis of group by concateante column adn show the part num based on Minimum change date and maximum chage date with in the group.
Delta is Curr Wei FSC (at minimun date) - Curr Wei FSC (at maximum date).
First part Num | last Part Num | Delta |
30Y0140 | 30Y0ABC | -10 |
30Y1534 | 30Y1534 | 0 |
30Y1532 | 30Y1532 | 0 |
30Y0989 | 30Y0100 | 18 |
Now if i click on the first row i should show the hostory of changes from 30Y0140 TO 30Y0ABC as below.
S.no | Part number Previous | Part number Current | Concatenate | Change Date | Type of change | Part Status | Prev Wei FSC | Curr Wei FSC |
1 | 30Y0140 | 30Y0140,30Y01XY,30Y0160,30Y0ABC | 05-01-23 | New cost item | New part | 10 | 10 | |
2 | 30Y0140 | 30Y01XY | 30Y0140,30Y01XY,30Y0160,30Y0ABC | 06-01-23 | Part Replacement | Part Change | 10 | 10 |
3 | 30Y01XY | 30Y0160 | 30Y0140,30Y01XY,30Y0160,30Y0ABC | 07-01-23 | Part Replacement | Part Change | 10 | 10 |
4 | 30Y0160 | 30Y0ABC | 30Y0140,30Y01XY,30Y0160,30Y0ABC | 08-01-23 | Part Replacement | Part Change | 10 | 20 |
Regards,
Narender.
yy
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26RhwelhH7t8q1cOVHo?e=zNbYsm
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
86 | |
82 | |
70 | |
49 |
User | Count |
---|---|
143 | |
122 | |
109 | |
60 | |
55 |