cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bgarland Regular Visitor
Regular Visitor

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 4
Super User
Super User

Re: Join and Filter Dimension Table

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.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





Super User
Super User

Re: Join and Filter Dimension Table

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.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





Super User
Super User

Re: Join and Filter Dimension Table

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

 

Thanks,

P






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





Moderator v-sihou-msft
Moderator

Re: Join and Filter Dimension Table

@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.

 

556.PNG

 

55.PNG

 

Regards,

 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 147 members 1,566 guests
Please welcome our newest community members: