Slicer not relating to multiple tables

[MBWATSON]

Hi Team Power BI!

I have two tables with a relationship that both have a text column called Date. They are formatted the same. I have created a matrix visual that pulls a different measure (Actions) from table 1 and another measure (Hours) from table 2. Looks good until I throw in a slicer visual. When I use the date measure from table 1 it slices only the Actions; when I use if from table 2 it only slices the hours. Any suggestions? Thanks in advance for your help!

[aj1973]

Hi @MBWATSON 

May I know why Date columns are of type Text?

[MBWATSON]

@aj1973 They are month and year and manually entered columns. They work in other tabs of the report as text to filter to the month desired. Those visuals also use multiple tables. Why text? That was the easiest way to enter them via "New Column" i.e. Date = "September" etc.

[aj1973]

Not sure if that's the only easiest way!

Do you want to share your file?

[MBWATSON]

Only if you promise not to laugh lol! I am a novice with Power BI and newish to this forum. Is there a way to attach a file or should I just copy and paste examples?

[aj1973]

😂😂

Here I won't lol anymore I promise. Don't worry I've seen worse.

You can share the file on Google drive or any online services 

[MBWATSON]

That is unfortunately not an option due to work restrictions. 

Table 1 (VIB Report)

Table 2 (VIB Hours)

Visual

[Ashish_Mathur]

Hi,

Your approach should be to create a Calendar Table.  Build a relationship (Many to One and Single) from the date column of both tables to the Date column of the Calendar Table.  To your visual, drag Date from the Calendar Table.

[MBWATSON]

@Ashish_Mathur This unfortunately did not work but thank you

[Ashish_Mathur]

Hi,

Share the download link of your PBI file.

[MBWATSON]

Also, I tried changing them to date format but it didn't change the outcome.