Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Display fixed columns on table visual

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 mo...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    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

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

Thank you!

 

That solved my issue.