power bi

[Mmd-Kb]

Hi 

im new to Power Bi and need help . 

How can i connect several colums from several tables so that it can be used in a filter . 

For example , we have several tables in which there is a date column in each table . i need to create a filter that when i selected march for example , all the charts that have been entered from different tables will work according to my filter . 

 best regards

[rajendraongole1]

Hi @Mmd-Kb 

Created a dedicated date table and provide the relationship in model view and try to check the visuals that should interact as expected based on the filter that used.

Thank you

[Mmd-Kb]

Can you please  show me a sample as a photo?

thx

[rajendraongole1]

Pleas find the attached snapshot.

[Mmd-Kb]

this is my data ( Excel ) 

number of rows in both tables is different.

[rajendraongole1]

Hi @Mmd-Kb 

you can use calculated table object and create a new table based on month Name and map/provide a relationship between tables, like that we can try and let us know. 

[Mmd-Kb]

Dear @rajendraongole1 

would you plz explain to me step by step

In my excel there are 2 sheets, table1 and table 2, and there is no mutual columns. I wanna make a relation beween them.

I appreciate you help me how can I do that.