Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Small multiples

Hello community,

I'm working with small-multiples, is there an option that switches between a single chart and small multiples based on the number of filter selections (example: showing one chart when "Select All" is chosen, and small multiples when multiple but not all are selected).

Thank you.

Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hello guys,

    Thank you for your answers.
    Finally I went with the solution of bookmarks, that's it !

    Thank you again.

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hello guys,

    Thank you for your answers.
    Finally I went with the solution of bookmarks, that's it !

    Thank you again.

    • v-tejrama's avatar
      v-tejrama
      Community Support
      1 year ago

      Hi Anonymous,

       

      I'm glad you found a solution and resloved  the query. Thank you very much for sharing here.

      Kindly mark your reply as the accepted solution so that others in the community can find it quickly.

       

      Thankyou for connecting with Microsoft Community Forum.

  • Akash_Varuna's avatar
    Akash_Varuna
    Super User
    1 year ago

    Hi Anonymous  I don’t think we have a built-in feature for switching between a single chart and small multiples based on filter selections. You can create a dynamic measure to count filter selections and use bookmarks to toggle between two visuals. 

  • v-tejrama's avatar
    v-tejrama
    Community Support
    1 year ago

    Hi Anonymous ,

    Thanks for reaching out on the Microsoft Fabric Community Forum.

     

    Here is a workaround I tried but its not possible to show single chart with small multiples.

    I’ve implemented this scenario by creating a disconnected category table for the slicer and used DAX to track selection count. Based on that, I created a  measure to dynamically switch between a single chart and small multiples both placed on the same page.

     

    Tested with below DAX:

    SelectedCategoriesCount = COUNTROWS(VALUES(CategoryTable[Category]))

     

    TotalCategories = CALCULATE(COUNTROWS(CategoryTable), ALL(CategoryTable))

     

    ViewMode = 
    VAR Selected = [SelectedCategoriesCount]
    VAR Total = [TotalCategories]
    RETURN 
        SWITCH(
            TRUE(),
            Selected = Total, 1,    
            Selected > 1, 2,      
            0                           

    )

     

    The visuals respond based on slicer interaction exactly as expected.

    Attached PBIX for reference.

     

    If response If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.


    Thank You!

    • v-tejrama's avatar
      v-tejrama
      Community Support
      1 year ago

      Hi Anonymous 

      We wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.

      If my answer resolved your query, please mark it as "Accept Answer" and give Kudos if it was helpful.

      If you need any further assistance, feel free to reach out.

      Thank you for being a valued member of the Microsoft Fabric Community Forum!