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, ...
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? 

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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi, 

        I saw the links but that doesn't solve my problem statement.