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
tone_radeu
Frequent Visitor

Date Segmentation Not Working with current Relationship

Hello all! I have been stuck with this topic for a while, and nothing I've done seems to be working.

I have this heavy dashboard, with a fat dataset that tells me some of the metrics of the company. There are 4 tables, and one Date dimension.

The 3rd page of the dashboard is the most important one, because it is an report that uses data of the 2 central tables in the Dash, with filters, segmentation, etc.
All of the filters of this section works, but one of the filters, the Date one, doesn't seem to be working.
See example below: (censored sensitive bits)

tone_radeu_0-1707936267590.png

tone_radeu_1-1707936375689.png

 

I tried do slice date from the entire period to the same day, but the values from the 2nd table does not change (1st and 2nd cards are from Table1 and 3rd card is from Table2).
Its data field from the Date dimension, and all of the tables have keys linked up to them. Here's the representation of the table's relationship:

tone_radeu_2-1707936745793.png

(Table1 is blue and Table2 is green)

How can I make the Date filter work?

Thanks in advance!

2 REPLIES 2
_AAndrade
Super User
Super User

I will check the both directional relationship between table blue and red and the same with green table.

To get green table PBI can use two ways.

One is from date table to green table and others using the blue table-->red table-->green table. 

This could be the problem





Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!




amitchandak
Super User
Super User

@tone_radeu , As you have 2 Bi-directional many-to-many relationships, the jin between the Date table and the table in green is inactive and it will not filter directly. And it will follow another path to filter.

 

If that is not working, You can create a measure that uses the date range from the slicer and filters the data 

 

example

new measure =
var _max = maxx(allselected(Date),Date[Date])
var _min = minx(allselected(Date),Date[Date])
return
calculate( sum(Table2[Value]), filter('Table2', 'Table2'[Date] >=_min && 'Table2'[Date] <=_max))

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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