The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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)
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:
(Table1 is blue and Table2 is green)
How can I make the Date filter work?
Thanks in advance!
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
Proud to be a 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))