Forum Discussion

Applicable88's avatar
Applicable88
Impactful Individual
4 years ago
Solved

Instead using bookmarks to switch visuals dimension using a dropdown menu

Hello, I once seen a report where someone uses a dropdown menu to switch the dimension between date, calendar week, month and year view of visuals. I find its a much more elegant way to do it, compa...
Need Help
Show and Tell
Tutorial Requests
parry2k's avatar
parry2k
Super User
4 years ago

Applicable88 you can following the technique shown in this post and tweak it as per your need.

 

✨ 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.⚡

  • Applicable88's avatar
    Applicable88
    Impactful Individual
    4 years ago

    Hello parry2k, thank you very much. I did take a look at it. As far I understand there is a difference in what the showed example displays and what I'm looking for. In the example it were practically switch between fixed  timeframes like "the last two months", "prior year", "last two weeks" etc. Whenever he switches the button he stays within the dimension of dates.

    What I try to find is a method to switch between daily, weekly, monthly and yearly. To make it possible for the barchart to switch they need to be in the same column of course:

     

    The first problem I have, that there is no calendar week function like week(), only weeknumber which is different. And the second problem is, when I switch from daily to monthly or yearly it will show me the first of the month or respectivley the first of the year, instead of simply Jan,Feb,Mar....or for year 2020,2021 bars:

    Years:

    Month:

     

    Changing the format for one column means it changes for all dimensions. I don't know, maybe someone knows a workaround for this.

    Best.