Forum Discussion
Matrix: Swap Column Headers
We can't directly have the formatting you desire. With work-arounds, yes we can acheive somewhat the same formatting.
I took 3 matrix vizes to achieve the formatting.
I have attached the pbix. Hope it helps you. You need to format further for specific colors and fonts.
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!
Proud To Be a Super User !!!
LinkedIn
If I swap the fields, I get LOB across the top which is not what I want. I've attached some sample dummy data below. For some reason, I can't attach a file, so I've included a table below. How do I attach a file or provide sample data? When I post a table, I get a message that I have invalid HTML.
You can attach the file to https://dropfiles.org/ and then send the URL generated. Best will be getting the pbix file. If you just wan't to share data, excel would work too.
Here's a link - see if you can open. It's a spreadsheet.
https://docs.google.com/spreadsheets/d/1JCH4gtLERteBO7QM3v43zY1PDNlIJ_AqX_6Xzuhxq_Q/edit?usp=sharing