Forum Discussion

Zakaria_1980's avatar
Zakaria_1980
Post Patron
5 years ago
Solved

need help please

Hi, i've two sheets, one called forecast & the other one called Actuals. i've tried to get one table showing me in rows project names , in columns periods and in values Forecast and actuals. the f...
Need Help
  • MFelix's avatar
    MFelix
    5 years ago

    Hi Zakaria_1980 ,

     

    You need to create two additional tables:

    Projects

    Periods

     

    Then make a one-to-many relationship with the other two tables will get something similar to this:

     

    Now creating a matrix visualization you can show the results:

     

    PBIX file attach.

     

     

     

MFelix's avatar
MFelix
Super User
5 years ago

Hi Zakaria_1980 ,

 

You need to create two additional tables:

Projects

Periods

 

Then make a one-to-many relationship with the other two tables will get something similar to this:

 

Now creating a matrix visualization you can show the results:

 

PBIX file attach.