Forum Discussion

pmalletucanss's avatar
pmalletucanss
Regular Visitor
6 years ago
Solved

How to display datas in multiple columns

Hello   Say we have this kind of table :   Branch TotalSurface A 10 B 20 C 30 D 40 E 50 F 60   We want this kind of display in a PBI report :   D 40 B 20 ...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    6 years ago

    Hi pmalletucanss ,

     

    There is no way to hide column headers directly. As a workaround, please refer to the settings in the screenshot:

     

     

    Best Regards,

    Dedmon Dai

v-deddai1-msft's avatar
v-deddai1-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi pmalletucanss ,

 

It seems there is no such a visual can meet your requirement without using visual script R.

 

As a workaround, I create two group for your sample data: A&D&F and B&C&E and I create two matrix to show data of them: One is filter with A&D&F and the other one was filtered with B&C&E:

 

 

For more details, please refer to the pbix file: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EaAm_WsjKJ5JvXJBpbQSAFUBK4IQtgq9oJMHaR7iefVSiw?e=4bN2d6

 

Best Regards,

Dedmon Dai

pmalletucanss's avatar
pmalletucanss
Regular Visitor
6 years ago

Thank you very much Dedmon Dai

 

However, just a next question : Is there a way to hide columns headers ?

 

A 10    B 20

D 40    C 30

F 60    E 50

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi pmalletucanss ,

     

    There is no way to hide column headers directly. As a workaround, please refer to the settings in the screenshot:

     

     

    Best Regards,

    Dedmon Dai