Forum Discussion

Wearehuman's avatar
Wearehuman
New Member
1 month ago
Solved

Removing empty visuals from small multiples Power BI

I have the below 100% stacked bar with small multiples. Is there a way to remove or hide those without any data items?

Many thanks

A

Need Help
Tips and Tricks
  • rohit1991's avatar
    rohit1991
    1 month ago

    Hii Wearehuman 

     

    The blank section is an unused row in the fixed small-multiples grid. Select the chart and go to Format visual > Small multiples > Grid layout, then set Rows = 1 and keep the required number of columns. Also ensure Show items with no data is disabled for the Small multiples field.

     

1 Reply

  • rohit1991's avatar
    rohit1991
    Super User
    1 month ago

    Hii Wearehuman 

     

    The blank section is an unused row in the fixed small-multiples grid. Select the chart and go to Format visual > Small multiples > Grid layout, then set Rows = 1 and keep the required number of columns. Also ensure Show items with no data is disabled for the Small multiples field.