Forum Discussion

Kevin086's avatar
Kevin086
Frequent Visitor
5 years ago

Problems with slicers and dimensions

Hi I am fairly new to databases and Power BI, after a day of research I still have the following problem:   For the overvieuw I'm using 3 tables, Companies (Consisting of companies), Verzuimmelding...
Need Help
TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
5 years ago

Hey Kevin086 ,

 

please create a pbix file that contains sample data, but still reflects your data model. Upload the pbix file to onedrive or dropbox and share the link. If you are using Excel to create the sample data share the xlsx as well.

Also describe the expected outcome based on your sample data.

 

Regards,

Tom

  • Kevin086's avatar
    Kevin086
    Frequent Visitor
    5 years ago

    Hey TomMartens , Thank you for your message. Hereby the dropbox link to the sample pbix file as well as the excel file where i made the sample data. The Location table is the full table which im using right now. The date table is implemented manually with: 

    Dim_Kalender = CALENDAR(Date(2015,1,1),TODAY())

     

    I have not connected the dimension tables: Date and Location, because, to solve my problem, both tables should connect to Verzuimmeldingen as well as Companies, which I can't figure out how.

     

    https://www.dropbox.com/sh/jhj7h4tn09nt0dw/AADiHQ7iX0IjK1iSe68cNBoDa?dl=0