Forum Discussion

bgarland's avatar
bgarland
Helper I
9 years ago

Join and Filter Dimension Table

New to PowerBI but couldn't find an answer to this. I have a simple model: a sales fact table joined to a master calendar table by invoice date. I am filtering the fact table to only get 2017 invoices but the calendar still returns rows for every day of all years. How do I get the calendar to respect the date filter I placed on the fact table?

4 Replies

  • parry2k's avatar
    parry2k
    Super User
    9 years ago

    Can you share what visual you have on your report? Make sure X axis type is set to categorical instead of continuous? I hope this will fix it, if not then please share the screen shot.

  • parry2k's avatar
    parry2k
    Super User
    9 years ago

    Can you check if type for X axis is set to categorical instead of continuous. if this doesn't fix, please share the screen shot.

    • parry2k's avatar
      parry2k
      Super User
      9 years ago

      Also can you tell how your tables are related, and what is relationship direction, single or both.

       

      Thanks,

      P

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    9 years ago

    bgarland

     

    You could add a slicer in your report. If you create table visuals for both calendar and fact table, it will slice all visuals based on the selection.

     

     

     

    Regards,