Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Minakshi
Resolver I
Resolver I

table relations

Hi all,

I have one base table and other is reference table of its. I want to use mutliple slicer with this. I created a relation ship between them and all the slicer works other than Date.

 

Kindly help me with this. How to make date slicer working along with other slicers.  table relationship for your reference.

 

Thanks in advance

 

Screenshot from 2020-07-24 21-59-12.png

1 ACCEPTED SOLUTION
Anonymous
Not applicable

@Minakshi 

Please try the following:


1. Create a another calendar table with Calendar(), enter the earliest date from the 2 table as start date, and use latest date from the 2 tables as end date.

 

Calendar table = Calendar(Date(),Date())

 

2. Relation both tables to the calendar table using [Date] column, you should have a many to one relationship, where both tables on the many side, and the calendar table on the one side.

 

3. Then, use the Date column in the new calendar table as slicer to filter visuals.


Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

7 REPLIES 7
Pragati11
Super User
Super User

Hi @Minakshi ,

 

From which table are you using the DATE slicer?

Based on your relationhip set-up, all the slicers sould come from Planogram Compliance table as the filter direction is set from this table to other table.

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

@Pragati11 yes, you are absolutely right. All the slicers are from planogram compliance table. But date and month are not filtering the data while others are doing perfect job.

Hi @Minakshi ,

 

This is should ideally work.

Can you share some screenshots on that it's not filtering with DAte filter? 

Also screenshot of your sample data?

 

what is data-type of DATE column in both of your tables?

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

@Pragati11 Date is of date type. Even month slicer is also not working. I tried to make a realtionship based on date then date and month slicers worked but others didn't. 

Screenshot from 2020-07-24 22-39-44.pngScreenshot from 2020-07-24 22-40-36.png 

 

attaching images for your reference. First with date filter selected and second without any filter. top 2 stacked bars showing same numbers. 

 

Hi @Minakshi ,

 

I think the issue might me in your calculations against FACTOR measure.

Try sharing it here.

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

@Pragati11 Factor is just for value, instead of 0 I want to write Non Compliant and insted of 1 , I want to write Compliant.

Factor = IF(value = 0, "Non COmpliant", "Compliant")

 

I think some other issue is there as I faced same issue with last time also and couldn't solve it.

Anonymous
Not applicable

@Minakshi 

Please try the following:


1. Create a another calendar table with Calendar(), enter the earliest date from the 2 table as start date, and use latest date from the 2 tables as end date.

 

Calendar table = Calendar(Date(),Date())

 

2. Relation both tables to the calendar table using [Date] column, you should have a many to one relationship, where both tables on the many side, and the calendar table on the one side.

 

3. Then, use the Date column in the new calendar table as slicer to filter visuals.


Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors