Select column in a slicer

[jx615k]

@TomMartens 

I have a table with multiple Date columns, is there a way a user can select which column they want to use in a slicer?  

Thanks in advance for your kind support! 

Sincerely Jordan

[VijayP · Accepted solution]

You can . But all Date Collumns in the fact table to be connected with DateDim[Date] and status will inactive except one base Date Relation. If I understood your question correctly you need to use USERELATIONSHIP Function to get this! let me know if this is helpful

[amitchandak]

@jx615k ,With multiple dates you can have a connection with all dates and then use userelation or crossfilter based on the need.

Please find an example on my blog

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[jx615k]

Thanks for the response Amit,

Maybe my question wasn't clear, Imagine I have many Date Columns (more than 40) for example HIRING_DATE, FINISH_DATE, LEAVE_DATE.... and the user needs to select one of those multiple columns and use a slicer so he/she can select a date or range of dates.

I was thinking having 2 slicers, one used to select a particular Column, and the second slicer used to select dates from that particular column.

You think that can be possible?

Thanks and regards.

[v-chuncz-msft · Accepted solution]

@jx615k 

If possible, you may also try Unpivot Columns in Query Editor.

[VijayP]

As per my understanding USERELATIONSHIP is the right answer. Hope you checked the Video and try apply on your model

[VijayP · Accepted solution]

You can . But all Date Collumns in the fact table to be connected with DateDim[Date] and status will inactive except one base Date Relation. If I understood your question correctly you need to use USERELATIONSHIP Function to get this! let me know if this is helpful

[jx615k]

Thank you so much for your quick response Vijay,

To be honest I am still getting familiarized with PowerBI and DAX, so is there any way you can explain it in a nutshell?

Thanks in advance for your kind support!

[VijayP]

https://www.sqlbi.com/articles/userelationship-in-calculated-columns/

Please try watching this Video. It will help you to understand the concept well

Also you can watch many DAX videos at www.youtube.com/perepavijay

Thanks and Regards

[jx615k]

Thank you Vijay, I already suscribed to your channel!