Forum Discussion

patyk's avatar
patyk
Frequent Visitor
8 years ago
Solved

pivoting table

 I would require to pivot the following table   On Power BI page I would need to see data as follows:   From Date extract Year Month  for example Aug-18, Sept-18, Oct-18, Nov.-18, Dec-18, J...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    Hi patyk

    If your purpose for pivoting table is just to show a visual like your screenshot, you could use the Matrix chart.

    Before add columns to the Field of Matrix, you need to sort the "date" column by ascending, then change the date format to "MMMM yyyy".

     

    If you need to pivot the table to change its structure, you could go to Edit queries

    1. sort the date column

    2.select "date" column, "pivot column"

    3.replace values

    replace "null" with 0

     

     

     

    Best Reagrds

    Maggie

v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi patyk

If your purpose for pivoting table is just to show a visual like your screenshot, you could use the Matrix chart.

Before add columns to the Field of Matrix, you need to sort the "date" column by ascending, then change the date format to "MMMM yyyy".

 

If you need to pivot the table to change its structure, you could go to Edit queries

1. sort the date column

2.select "date" column, "pivot column"

3.replace values

replace "null" with 0

 

 

 

Best Reagrds

Maggie