Values by month

[Anonymous]

I have a matrix set up like so

june

      orders

      sales

      income

july

      orders

      sales

      income

and so on with the months of the year. I want to organize it like this though

orders

     june

     july

     august

    september

and so on with the rest of the months, then the next account, sales, to do the same thing. does anyone know how to organize a matrix in such way?

[mickey64 · Accepted solution]

Step 0: I use this data table. (Date: yyyy/mm/dd)

Step 1: I fill down the 'Date' column on Power Query Editor.

- Before -

- After -

Step 2: I filter the 'Class' column on Power Query Editor.

- Before -

- After -

Step 3: I click 'Close & Apply' on Power Query Editor.

Step 4: I make a matrix on Power BI Desktop.

[ryan_mayu]

usually you only need to create measures and add measures to the matrix. Could you pls provide some sample data and the expected output?