Repeated value missing

[Anonymous]

Dear all

I have two tables as shown:

table1 contain po number(have repeated value) and eng discipline

and

table2 contains  po number(not repeated value) and kom date(repeated value)

i make relation many to one between table1 and table2 through PO column

create table in power bi report as shown below by serial po number,kom date, eng discipline

whebever i arrange the column in way: po number , eng discipline, kom date then repeated value in kom date not appear as shown below:

 is there any solution to get all cell value

Thanks

 

 

[smpa01]

@Anonymous  did you try the above?

[smpa01 · Accepted solution]

@Anonymous  create an index column in t1 using PQ and bring that index column in viz in order to see the repeated values.

[Anonymous]

i tried by adding index colummn, but still same issue