Two Dates from two columns of a table to add on a single slicer

[Jenni_Zen]

Hi Everyone,

I am new to PowerBI, so please bear with me 🙂

I am trying to create a date slicer for a report as in the second pic. Values highlighted will be coming from two different columns of a table (1st pic) . Is this possible? If not, any alternatives? Any help is appreciated.

Thanks in advance

[Shaurya]

Hi @Jenni_Zen,

If these dates are coming from different columns and you want to filter fields that are different as well then I suggest that you create two slicers. You can pull in the date in the first slicer and use it to filter visuals that are related to that date and same for the second date column. Make sure that you turn off interactions between visuals that are not related to prevent any mismatch in the data.

Works for you? Mark this post as a solution if it does!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI

[Jenni_Zen]

Hi @Shaurya 

Thank you for the reply. If some more details could help.

The slicer will filter some chart visuals like the one below. The dates you see on the chart are coming from a different field of a different table (Sales) which does not have a direct relationship with this (Order Date) table.

so if I was to put it in sql, this is what I am trying to display on the chart ..

-- Chart Display---

SELECT Sales.MainDate, Sales.[StockArr], Sales.[StockArrEstimate]
FROM Station INNER JOIN (Store INNER JOIN (Contacts INNER JOIN Sales ON Contacts.ID = Sales.StoreID) ON Store.[StoreID] = Contacts.[Name]) ON Station.[StationID] = Store.Station

---Add the below to a slicer---

WHERE (((Sales.MainDate) Between OrderDate.[StartDate] And OrderDate.[EndDate]) AND ((Contacts.[Name])=StoreName));

Any idea how I can setup the chart to behave correctly ?

Thanks in advance

[Anonymous · Accepted solution]

HI @Jenni_Zen,

It seem like a common multiple date field analysis requirement, you can take a look at the following blog ‘start date’ ,’end date’ part if helps:

Before You Post, Read This 

Regards,

Xiaoxin Sheng