keep duplicate value in a visual table or matrix

[Anonymous]

Hello, I have a question. Do you know if it possible to keep duplicate value from a table/matrix visual ?

Exemple : I have a table like below (2 columns id and name)

id name

1  a

1  a

2  b

In my visual I have:

id  name

1  a

2  b

what I want 

id name

1  a

1  a

2  b

Thanks in advance.

[mickey64]

For your reference.

Step 1: I add an Index Column in Power Query Editor.

    

    

Step 2: I maka a 'Table' visual in Power BI Desktop.

    

Step 3: I change width of the table.

    

[Anonymous]

Hello @mickey64 ,

Thanks for this solution but I forgot to specify before (my bad) but it's for a csv extraction. 

I want an extraction without the index and with the table like I said below:

id name

1  a

1  a

2  b

Thanks in advance.

[Anonymous]

Hi @Anonymous ,

According to your statement, I think you want to export underlying data into csv file.

As far as I know, Power BI will summairze the duplicate data. If you want to export duplicates as you mentioned to csv, I think you need to add an index column to expand your visual.

Or here I have a workaround to achieve your goal without adding an index column.

I think you can summarize [ID] column and then export underlying data in Power BI Service.

Result is as below.

Then save your .xlsx file as .csv file.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hello, thanks for this solution.

I don't have this screen in power bi desktop (I have the free licence). Do we need a pro or premium licence to have this type of export ?