Forum Discussion

jx615k's avatar
jx615k
Frequent Visitor
6 years ago
Solved

Select column in a slicer

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 ...
Need Help
  • VijayP's avatar
    VijayP
    6 years ago

    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

  • v-chuncz-msft's avatar
    v-chuncz-msft
    6 years ago

    jx615k 

     

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

jx615k's avatar
jx615k
Frequent Visitor
6 years ago

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's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
6 years ago

jx615k 

 

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