PBI perform inner or outer join

[ondrej-cdc]

Hello everyone,
I would like to aks you about data modeling in Power BI. If I choose my tables set like star schema at model I dont understand how to set inner join or outer join. If I will be specific there is my fact table and dimension table with dates.

Fact table named "transport"
"id";"period_key";"vehicle_key";"kg"
"1";"20230801";"12";"22,0"
"2";"20230801";"14";"24,0"
"3";"20230901";"12";"21,0"
"4";"20230901";"14";"27,0"
"5";"20230801";"14";"4,0"
"6";"20231001";"5";"6,0"
"7";"20231001";"10";"2,0"

Dimension table with dates named "dates"
"period_key";"quarter","name"
"20230801";"Q3";"August"
"20230901";"Q4";"September"
"20231001";"Q4";"October"
"20231101";"Q4";"November"

Then a set up join with "period_key" and I would like to filter in report with dates.name, I want to have to choose only with matching values. So at the filter there have to be values to choose August, September, October. How this could be solved? And if I have a much more dimension tables?

Thank you in advance,
Best regards,
Ondrej

[lbendlin]

those are slightly different concepts. Read about AutoExists.

[RamyaKrishna_61]

I read about autoexists. But In my model I do have fact and dim.

fact table contains
sales product_key  
20     1                         

30     2                         

40    3                          

in my product table I do have only A,B products.
Product_key   Product
  1                    A

  2                    B

then when I consider my sales from fact and product_ID from Product table then I am seeing as below
Sales Product

20      A

30      B

40  

here I am seeing blanks in Product. Which is not expected from my user. They are expecting only inner join. How to achieve this.

I don't want any inner join in my query editor.

 How to achieve this.