Matrix: Swap Column Headers

[ConnieMaldonado]

Hello - I have a table in which I'm showing by Line of Business (LOB) and quarter (in 2020), total classroom training hours and Training Ride Along hours.  I put the data in a matrix as follows:

What I really want is Class Room Training by quarter, then Training Ride Along hours by quarter as follows:

Questions:

1.  Is it possible to easily swap the layout?

2.  I have data from 2018, so when you use the "Qtr" component of the date, does it sum for all years?  I put a filter on the visual to look at only 2020.

3.  In the first graphic, why are the column headers for the Totals (circled in red) so blurry.  That's strange, when the other column headers are not.  No big deal.

Thanks!

[ConnieMaldonado]

Thak you!  I was able to make it work with the suggestions in the PBIX.  How were you able to attach a document to the post? 🙂  I can't seem to do that.

[Anand24]

@ConnieMaldonado , Attachment option with comments/replies is available only for users with Super User rank. That's why it's not visible to you.

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

[ConnieMaldonado]

Here's a link to the sample data:

https://docs.google.com/spreadsheets/d/1JCH4gtLERteBO7QM3v43zY1PDNlIJ_AqX_6Xzuhxq_Q/edit?usp=sharing

[Anand24 · Accepted solution]

@ConnieMaldonado ,

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

[ConnieMaldonado]

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.  

[Anand24]

@ConnieMaldonado ,

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.

[ConnieMaldonado]

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

[Anand24]

Hi @ConnieMaldonado ,

PFB response:

1. Is it possible to easily swap the layout?

Ans: Yes. Seems like you have taken Qtr first and then LOB in matrix columns. Switch them in the fields. You can achieve using a bit of tweak. It would be better if you provide sample data so that we can try and attach solution file.

2. I have data from 2018, so when you use the "Qtr" component of the date, does it sum for all years? I put a filter on the visual to look at only 2020.

Ans: Yes. You will need to take Year alongwith QTR to get the diiferentiation.

3. In the first graphic, why are the column headers for the Totals (circled in red) so blurry. That's strange, when the other column headers are not. No big deal.

Ans: Seems to be an internal bug. This sometimes does happen. Try increasing/decreasing font size and changing font-style. Also, try disabling the totals and then enabling them.

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