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

Thank you Vijay, I already suscribed to your channel!