Matrix Table with Month and Quarter's Side by Side

[Anonymous]

Hi,

I'm hoping someone might be able to help me out. I've had a look around and can't find a solution. 

I am wondering if the below set out is possible. I want to be able to see Months and Quarters side by side and not have to drill down in the visual. The GSV, Net Sales and Gross Profit rows are measures that I have created using DAX. I've been trying to work this out by using a Matrix Table with three measu re values, that are Shown on Rows. Haven't been able to work out how to format the columns.

Thanks.

[Lily36876]

Hi 

Can I ask that how you write to calculate total of GSV, Net Sales and Gross Profit each rows with Dax!!!

I have same demand with it!!! Thanks a lot!!

[petrutjim]

same question here, but the accepted response does not solve the initial request.

[amitchandak]

@Anonymous , I think the case of measure on the row. You need use "Show on Row"

Please refer to this link

https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

[Anonymous]

Thank you for your reply. This however is not what I'm trying to solve for. I have been able to show my measures on row. 

What I'm trying to solve for is how do I get Months and Quarter columns to show next to each other, rather than dril down. Is it even possible?

Thanks.

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

Try to turn off the 'Stepped layout' option.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.