Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Shreeram04
Resolver III
Resolver III

Header For A Multiple Columns

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 CodeJanFebMarAprMayJunOctNovDecAreaCountry
A200100300400200100100300400APACTaiwan
B305075103050507510APACTurkey
C602811876028281187ChinaChina
A4064390406464390SAMArgentina
A346958483469695848SAM Mexico
B567232815672723281EMEASaudi Arabia
C7631145763131145APACThailand

 

To this:

 

Shreeram04_0-1653041347061.png

 

Thanks in advance.

1 REPLY 1
negi007
Community Champion
Community Champion

@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

negi007_0-1653045253806.png

 




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos



Proud to be a Super User!


Follow me on linkedin

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors