Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to show same value in table visual without summarizing

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.

Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    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.

5 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    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
     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      thank you selimovd, but unfortunately still the same result

  • Msta's avatar
    Msta
    Helper I
    5 years ago

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

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

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    5 years ago

    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.