Visualization Q: Matrix first row show 1 column then from second row show split column

[akhaliq7]

I am trying to show a matrix that will display number of orders by month in a matrix. For the first row it shows one column for each month. From the second row need to show two columns by month to show the total count broken down further alongside a percentage in the second column.

                                           JAN                 FEB                      MAR

NUMBER OF ORDERS        100                  119                     130 

£1000 - £5000                    60      60%       76      63.9%        60      46.2%

£5001 - £10000                  30      30%       20      16.8%        50      38.4%

>£10,000                            10      10%       23      19.3%        20      15.3%

How can I acheieve the above result?

[Anonymous · Accepted solution]

Hi @akhaliq7 ,

Please check  the model.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum