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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Two date columns in one table

Hi! I currently have a table with a "Created On" and "Deactivated On" date. In my dashboard, I have these separated into two separate visuals but I want to have a date slicer that has the same effect on both. For example, if I want the date to be 6/1/2023 to 6/19/2023, I want the first table to show all cases created in that range and the second table to show the cases deactivated in that range. When I do this now it only accounts for the "Created On" date which gives me smaller results in the deactivated table. Does anyone know if there is a way to do this

Super User
Super User



You'll need to have a date table with both the date fields joined to it. Then create measures that you use to calculate a count of records to be used in your charts and use the USERELATIONSHIP fucntion to switch the active relationship to whichever field you want to use.


If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors