Forum Discussion

miltonayala's avatar
miltonayala
Frequent Visitor
8 years ago
Solved

Dynamic Slicer based on Slicer

Hi everyone.   I am triyng to get a slicer data type to change dynamically according to the value selected in another slicer and would appreciate some guidance on how to solve.   Picture 1:...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi miltonayala,

     

    I'm afraid it is not possible to dynamically change the data type of values shown in slicer. In this workaround, it looks like fields displayed in slicer are dynamic, actually, all displayed selections in slicer are from a single column. But one column can have only one data type. Based on my test, there is no workaround to achieve such a requirement.

     

    Regards,

    Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
8 years ago

miltonayala

Is it not possible for you to relate 2 tables and use Edit Interactions so that your slicers dynamically change based on each other.

 

Regards

  • miltonayala's avatar
    miltonayala
    Frequent Visitor
    8 years ago

    Anonymous 

    Thanks for your comment, however it was already done (through a workaround) in the option shown in the picture 2. In that option my issue is how to dynamically change the data type for the new slicer.

     

    Any thoughts? 

    • miltonayala's avatar
      miltonayala
      Frequent Visitor
      8 years ago

      I would like to dynamically change the data type of a slicer based on the selection on another slicer and would appreciate any help or guidance on the topic.  Date type is currently shown in as text (in picture 2) but I need it to change to date  or text and date dynamicaly depending on the value on the independent slicer. Any suggestions would be highly appreciated.

       

       

      Picture 1Picture 2, Current type: Text, Desired type :Date