Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi All,
My requirement is I need a header for some particular columns in a table. For example, if I have an area and country column means it shows under the Region header. How can I achieve this one?.
Sample data:
From this
Product Code | Jan | Feb | Mar | Apr | May | Jun | Oct | Nov | Dec | Area | Country |
A | 200 | 100 | 300 | 400 | 200 | 100 | 100 | 300 | 400 | APAC | Taiwan |
B | 30 | 50 | 75 | 10 | 30 | 50 | 50 | 75 | 10 | APAC | Turkey |
C | 60 | 28 | 11 | 87 | 60 | 28 | 28 | 11 | 87 | China | China |
A | 40 | 64 | 3 | 90 | 40 | 64 | 64 | 3 | 90 | SAM | Argentina |
A | 34 | 69 | 58 | 48 | 34 | 69 | 69 | 58 | 48 | SAM | Mexico |
B | 56 | 72 | 32 | 81 | 56 | 72 | 72 | 32 | 81 | EMEA | Saudi Arabia |
C | 76 | 31 | 14 | 5 | 76 | 31 | 31 | 14 | 5 | APAC | Thailand |
To this:
Thanks in advance.
@Shreeram04 in your visual you are having i guess sales by month and then you wish to add another value of text type i.e.e area and country is not possible. matrix visual will show first value against all header which is month case and if you add another value that will also be shown against all headers which will not give the correct result.
in this case, you can either use textbox or reactangle shape to show header for last two columns and seperate header for month values. this is the quick workaround solution that can be used for now.
also, were you able to create the first visual that you have shared above
Proud to be a Super User!