Forum Discussion
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 |
| F | 60 | E | 50 |
| A | 10 | C | 30 |
With the 'table' visual, thers is no avalaible property for "multi-columns"
I'm newby on PBI, the only way I did find to achieve it was ... to use visual script R !
Thank you very much !!
(excuse me for my poor english, I'm french)
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
4 Replies
v-deddai1-msftCommunity Support
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
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
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
- amitchandak
Super User
pmalletucanss , refer if this can help
https://www.youtube.com/watch?v=WSnB5y2JXv8
I am hosting a webinar on 25th April on Power BI, Check Details - https://www.linkedin.com/posts/amitchandak78_webinar-tech-techforgood-activity-6658266754378231808-ye5L
