Forum Discussion

davidkerr's avatar
davidkerr
New Member
9 years ago

Sharepoint list - Table with Date as Column

Hi,

I have a Sharepoint List with:

Date ( in date format)

Measure 1

Measure 2 

Measure 3

The date is put in each month as Month/01/Year

So you have row:

Date, Measure 1, Measure 2, Measure 3

 

I have been using Tableau (but switching to BI)

and with it you can drag the date as a dimension and than the rest of the measures as Rows so you have:

(taking the date as a year)

 

                      2007  2008 2009

Measure 1

Measure 2

 

I am at a loss how to do this in Power BI and I must be not searching the correct terms.  Any pointers would be much appreciated.

Thanks

David

2 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee

    davidkerr

     

    In Power BI, you can't have both measures appear in Row Group simultaneously. We can only put both of them into Value pane, then it will show corresponding values sliced by Date Hierarchy under Column Group.

     

     

    Regards,