Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Set the selected time range in slicer

Hello,   I have a time range slicer in the report, binding to a Datetime column in the data source. Is it possible to have some helper buttons to change the selected time range in the slicer? Like ...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

Anonymous nothing out of the box but you can work around with another table, this post can help.

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    parry2k Thanks for the info. Not sure if I missed anything in the article, is there a way for this kind of Time Intelligence table to work with a "between" date slicer?

     

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      6 years ago

      Anonymous so you will have this extra table will filter your date table. Solution should work to meet your expectations.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        parry2k I am playing with the example posted in the article. A chart and a slicer based on the date column in the filtered table are added to the report. When the period selection is changed, I can see the chart axis is changed with it correctly, but the slicer always shows the whole time range. My assumption is since this slicer is a filter for the date, it overrides the filter the Time Intelligence table applies to the data source. How can I change the selected range in it based on the selected period?

         

        The chart axis is changed to two months, the slicer is not:

        I was expecting something like this: