Forum Discussion
Select column in a slicer
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
8 Replies
- VijayP
Community Champion
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
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
- amitchandak
Super User
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
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.
- VijayP
As per my understanding USERELATIONSHIP is the right answer. Hope you checked the Video and try apply on your model
