Forum Discussion
Helper Idon't group text on visual
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 |
| ... |
|
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,
KellyDid I answer your question? Mark my post as a solution!
4 Replies
- amitchandak
Super User
If name are same they will grouped on visuals. The way our create a concatenated column
id name = [Name] & " " & [ID]
skutovicsakosThats is exactly what I was thinking, but I want to know if there is a way to show only the document name.
v-kelly-msftCommunity Support
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,
KellyDid I answer your question? Mark my post as a solution!
