Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Making Slicer functional

Hi all, 

I want to ask one thing that I have made one slicer named frequency that contains SELECT ALL,  WEEKLY, MONTHLY, QUARTERLY. Also, I have used 45 card in my dashboard ( 15 each for WEEKLY, MONTHLY, QUARTERLY ), So i want when I press weekly, i just want only 15 weekly cards , when i press monthly , i want only 15 monthly cards.

Also, I can also choose weekly and monthly both at the same time so that I will get 30 cards ( 15 for weekly and 15 for monthly) and so on. Such type of thing I want in my dashboard.

Can somebody please help ?

Thanks !

Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    Hi Anonymous ,

    Does the blog above work for you? If it makes sense, can you please accept the helpful answer as a solution? 

7 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous first and foremost, having 45 visuals is really a bad design, each visual is going to send a query, means 45 queries and this will lead to a very performance, you should be looking into different visual, like table/matrix or other visuals

     

    Regarding hide and show visuals based on selection, you have to look into button and page navigation and that is your best option.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi, 

      I got your point regarding the performance levels, but as per my UI card is the best visualisation I found in Power BI.
      By using table/matrix instead of cards hampers my UI , that's why not using them, actually no UI change is allowed in my project, earlier the report was built in jaspersoft and now i am migrating it to power bi.

      Thanks !

      • v-xuding-msft's avatar
        v-xuding-msft
        Community Support
        6 years ago

        Hi Anonymous ，

        I see. 

        For your original post, you could reference the links that I suggested above to have a try. If you have any questions, please feel free to ask us.

         

        Best Regards,

        Xue Ding

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support
    6 years ago

    Hi Anonymous ，

    You could reference the links to change your visuals using toggles. If you want to use slicers to implement it directly, it is impossible.

    Reference:

    https://www.youtube.com/watch?v=_Afcj8mT5_Q

    https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

    https://www.blue-granite.com/blog/using-data-driven-images-for-navigating-power-bi-bookmarks

     

    However, as parry2k said, your report will be with bad performance. You could reference the documents to optimize it.

    Optimization guide for Power BI 

    Use Performance Analyzer to examine report element performance 

     

    Best Regards,

    Xue Ding

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.