Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

PowerBI Time Slicer

Hello everyone,   I read through quite a few posts in the archive about time slicers (not date slicers), and it seems like the feature is not available.   Now in 2021, are there any work arounds ...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi Anonymous 

     

    Not sure which kind of time slicer you are referring to, but it seems to be an unavailable feature currently. 

     

    If you want to have a hierarchy time slicer, you need to have Hour/Minute/Second columns in the table in advance. Then you can create a custom hierarchy in Fields pane. Right click on Time column and select Create hierarchy. Right click on Hour/Minute/Second columns one by one and select Add to hierarchy > hierarchy name (the hierarchy created in previous step).

     

    You can use this custom hierarchy in slicers and other visuals. 

     

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 years ago

Anonymous there is a relative time slicer, not sure if this is something that can help. Use a relative time slicer or filter in Power BI - Power BI | Microsoft Docs

 

✨ Follow us on LinkedIn

 

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to 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
5 years ago

Thanks for the reply.  Unfortunately, I would need this dashboard to zoom into second-frequency data from within the historical database as well.  The relative time filter only allows the user to see the most recent events :(.