Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Repeated value missing

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

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

3 Replies

  • smpa01's avatar
    smpa01
    Community Champion

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

    • Anonymous's avatar
      Anonymous
      Not applicable

      i tried by adding index colummn, but still same issue