Dynamic column in matrix

[Anonymous]

Hi, 

I have a matrix with multiple rows, each of them having a set of values (status of employes). I need to show them side-by-side for each row  (see image 1).image 1

I achieve this by creating a sequence in my sql query which I used as column to split the data on the matrix. 

I got some problems with this 'solution', first is that I can't slice by status since they have this fixed column and the visual stay with this open space... (see image 2).

image 2

Another thing I need is, when I drill-up or down, the status should keep showing side-by-side all the values, but they got summarized as first value and replaced other values on the same columnn (see image 3).

image 3

Is this possible to achieve?

(If something was not clear please let me know, I'll try to explain better, sorry for my english :\)

ps: idk how to upload a file for example 😞

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You may take a look at the following posts.

• https://community.powerbi.com/t5/Desktop/using-date-from-1-of-joins-for-the-graph/m-p/585665#M277506
• https://community.powerbi.com/t5/Desktop/Matrix-only-show-first-or-last-value/td-p/337627

[Anonymous]

Thanks! I've used the concatenated method, it was a problem first because my values were links to images (icons), but I solved it by using emojis instead  🙂