Small multiples

[PBIDev01]

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.

[PBIDev01 · Accepted solution]

Hello guys,

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

Thank you again.

[v-tejrama]

Hi @PBIDev01,

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.

[v-tejrama]

Hi @PBIDev01 ,

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]

Hi @PBIDev01 

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!

[Akash_Varuna]

Hi @PBIDev01  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.