Display fixed columns on table visual

[Anonymous]

Hello!

I'm currently having the following situation:

I have a list of IDs, 20 modules and a count per module.

So I'm creating a table visualization in which there are 20 columns (1 per module), and each row should be the client id, followed by the count per module.

The problem is that not all clients have entries for all modules. And if I click on a client ID, it refilters the columns and shows only columns for which that client has an entry.

So if the client has entries associated with modules 1,2, and 5, if I select it on the table it will resize the table and show only columns 1, 2 and 5, while I want it to keep showing columns 1 to 20 (Empty, for the modules in which the client doesn't have any entries for). 

Is there any way of fixing the columns shown at all times? Last case scenario I could try to generate rows with count 0 for the modules missing, but this seems even more complicated.

Anyone knows if I can achieve this visually?

[v-yulgu-msft · Accepted solution]

Hi @Anonymous ,

Suppose the source table ('Data_6') is like below.

New a calculated table which is linked to source table.

module dimemsion = VALUES(Data_6[Module])

Insert a Matrix visual. Please note that you should drag [Module] from 'module dimension' table.

Best regards,

Yuliana Gu

[Anonymous]

Thank you!

That solved my issue.