don't group text on visual

[skutovicsakos]

First let me show the data:

date	action	docID	docName
not important	not important	111	not log
not important	not important	123	log
not important	not important	123	log

I want to show visualize many actions were for each document (docID), but I want to show the document name. In other words, I do not want power bi to group the names on the visual. Is there a way to do this?

This is what I get now: 

What I would like to get (docName, Count of Actions):

Log	1111
Log	222
log file	132
Log	111
log file	13
...

[amitchandak]

If name are same they will grouped on visuals. The way our create a concatenated column

id name = [Name] & " " & [ID]

[skutovicsakos]

Thats is exactly what I was thinking, but I want to know if there is a way to show only the document name. 

[v-kelly-msft · Accepted solution]

Hi @skutovicsakos ，

You need to add an index column to separate each row,see below:

1, Go to query editor> add column >Index column:

Then add the index column to the table visual and hide it,see below:

Set "word wrap" under "column header" and " value" off,

And you will see:

I made a sample .pbix file you can refer to.Pls click here.

 
Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[skutovicsakos]

Thank you @v-kelly-msft,

I will accept this as a solution, because it solves the original question, but this method does not work on all visuals. Is there a way to get the same result on a bar chart?