Forum Discussion

prabhuk's avatar
prabhuk
Helper I
5 years ago
Solved

Error in matrix table

Hello, can you help in identifing the error in the attached file. when i add reagion along with sales and commit table i am getting error. https://www.dropbox.com/s/yly9bouar7rjfz5/BI%20File.pbix?d...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    Download the PBI file from here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

Your tables and relationships are not properly set up.  You should create a Calendar Table and build a relationship from the Date columns of the Budget and Sales table to the Date column of the Calendar Table.  The region column of the Budget and Sales table should also be connected to the Region column of the Region table.  There should be no relationship between the Budget and Sales table.  Any time period related slicer (Year/Month Name) should be dragged from the Calendar Table.