Forum Discussion
powerlight1
Helper I
Helper IOR condition on multiple slicers
I am trying to implement a similar solution to Solved: OR condition on multiple slicer selections - Microsoft Fabric Community but my problem is that I have 2 Tables with 1 column from each table tha...
Next time I'll provide data in the suggested links.
I've worked it out.
Thanks community for your support.
hackcrr
Memorable Member
Memorable MemberHi, powerlight1
In your table2, EventName = Birthday Sales
The date range for the EventName = Birthday Sales is from March 7, 2024 - May 7, 2024. Therefore, when you select 'Birthday Sales' in the Event slicer, your chart will display data within this time range based on the relationships you have established. The criteria from your other date slicer will further filter the data based on this date range.
You can publish your report click blow button：
powerlight1Date are all in dd/mm/yyyy format as we're in Australia.
- powerlight1
I am unable to publish based on the method you said as or organisation is blocked from Fabric. I will try to publish from my private account.
I don't agree with you that the relationship between the Events and Sales table are causing only 3/7-5/7 sales to be returned as I have created the OR Filter measure to also return all dates from the SalesDate table:
OR Filter =IF(MAX(Sales[Date]) IN ALLSELECTED(SalesDate[Date]) || MAX(Events[Event Name]) IN ALLSELECTED(EventName[Event Name]),1,0)