Forum Discussion

bgarland's avatar
bgarland
Icon for Helper I rankHelper 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 invoice...
v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft 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,