How to show same value in table visual without summarizing

[Anonymous]

Hello,

i have a problem in the table visual, which shows the distinct values not the table, if e. g. the value is more than one time in the list. 

my salesline table includes the following positions for a salesorder:

But in the visual i can only see the following list:

i only see every line, if i add the position number, but this is not what i want. 

is there any way to show the three lines without the position number?

thank you in advance.

[v-henryk-mstf · Accepted solution]

Hi @Anonymous ,

I did a test, you can add an index in the power query, and then add it to the table visual, you can get the results you expect.

Let me know immediately, looking forward to your reply.🙂

Best Regards,
Henry

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

[Msta]

Select your Price and Orderumber column and check Summarization maybe you have here "MAX"/"MIN"

[Anonymous]

thank you Msta, All columns are selected with "Don´t summarize", but still the same

[selimovd]

Hey @Anonymous ,

you can make it show all the rows.

Click on the ordernumbers and chose "Don't summarize":

Afterwards you should see all the rows.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

thank you selimovd, but unfortunately still the same result