Forum Discussion

ConnieMaldonado's avatar
ConnieMaldonado
Responsive Resident
5 years ago
Solved

Matrix: Swap Column Headers

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: ...
Need Help
  • Anand24's avatar
    Anand24
    5 years ago

    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
Anand24's avatar
Anand24
Super User
5 years ago

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