Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get 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

Reply
tangutoori
Helper III
Helper III

Contains in Column

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.

 

tangutoori_0-1680703818207.png

Regards,

Narender.

 

1 ACCEPTED SOLUTION
7 REPLIES 7
Ahmedx
Super User
Super User

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

Screen Capture #822.pngScreen Capture #823.png

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])

 

tangutoori_0-1680744611845.png

Regards,

Narender.

 

superb Man.. thanks for quick respose.

Hi ahmed,

here is the full scenario.

 

below is the source data.

 

S.noPart number PreviousPart number CurrentConcatenateChange DateType of changePart StatusPrev Wei FSCCurr Wei FSCPrev Tar FSCCurr Tar FSCQty PrevQty Curr
1 30Y014030Y0140,30Y01XY,30Y0160,30Y0ABC05-01-23New cost itemNew part1010151711
230Y014030Y01XY30Y0140,30Y01XY,30Y0160,30Y0ABC06-01-23Part ReplacementPart Change1010151711
330Y01XY30Y016030Y0140,30Y01XY,30Y0160,30Y0ABC07-01-23Part ReplacementPart Change1010151711
430Y016030Y0ABC30Y0140,30Y01XY,30Y0160,30Y0ABC08-01-23Part ReplacementPart Change1020121811
5 30Y153430Y153411-01-23New cost itemNew part1010151311
6 30Y153230Y153212-01-23New cost itemNew part1010151311
7 30Y098930Y0989/30Y010013-01-23New cost itemNew part1010151311
830Y098930Y010030Y0989/30Y010014-01-23Part ReplacementPart Change1010151311

 

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 Numlast Part NumDelta
30Y014030Y0ABC-10
30Y153430Y15340
30Y153230Y15320
30Y098930Y010018

 

Now if i click on the first row i should show the hostory of changes from 30Y0140 TO 30Y0ABC as below.

 

S.noPart number PreviousPart number CurrentConcatenateChange DateType of changePart StatusPrev Wei FSCCurr Wei FSC
1 30Y014030Y0140,30Y01XY,30Y0160,30Y0ABC05-01-23New cost itemNew part1010
230Y014030Y01XY30Y0140,30Y01XY,30Y0160,30Y0ABC06-01-23Part ReplacementPart Change1010
330Y01XY30Y016030Y0140,30Y01XY,30Y0160,30Y0ABC07-01-23Part ReplacementPart Change1010
430Y016030Y0ABC30Y0140,30Y01XY,30Y0160,30Y0ABC08-01-23Part ReplacementPart Change1020

 

 

Regards,

Narender.

 

 

 

 

Ahmedx
Super User
Super User

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

Screen Capture #819.png

 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.