Small multiples

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!