Matrix/Table Format Question

[Anonymous]

I'm trying to format a visual that would look something like below:

Jan                    Feb

$123,456,789    $123,456,789

                123                   123

It would continue across the page for each month of the year, the next line is sum in dollars of a field, and the last line is a count of the records that made up the sum above it.  So far using a Matrix visual I'm able to get the following:

Jan                               Feb

Dollars            Units     Dollars            Units     

$123,456,789    123      $123,456,789    123      

And on across the page.  Is there a way to get a Matrix or Table visual to format the data the way that I want it in the first example?

Thanks In Advance

Scott

[parry2k]

@Anonymous good to know. Cheers!!

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

[AlexisOlson]

You can use Switch values to rows to match your desired format:

[Anonymous]

Thank you!

[parry2k · Accepted solution]

@Anonymous on formatting pane, turn on show on rows option and that will do it.

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

[Anonymous]

I think that's got it.

Thank you!