Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
amon151
Frequent Visitor

Remove horizontal gridlines from small multiples

I have a small multiples in this clustered column chart but I'm unable to remove the dotted, horizontal gridlines.  Any ideas on how I can get rid of them?

 

amon151_0-1704829166964.png

 

As you can see below, the gridlines options are grayed out and it won't allow me to turn on/off.

 

amon151_1-1704829312833.png

 

 

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@amon151 

Not faced this issue, however, try to create a new visual on a blank page and try to apply the same settings, then compare what you have done differently in this visual.


Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

4 REPLIES 4
PedroDavidGomes
New Member

Hello, 

 

I also faced this issue and what worked for me was:

 

  1.  Go to Format -> Visual Y-axis -> Turn on Values 
    PedroDavidGomes_0-1740671239524.png

     

  2. Go to Gridlines -> Horizontal (now you can turn them off)
    PedroDavidGomes_1-1740671343849.png

     

    3. Go back to Y-axis -> turn Values off 
    PedroDavidGomes_2-1740671514633.png

Thank you 🙂

Fowmy
Super User
Super User

@amon151 

Not faced this issue, however, try to create a new visual on a blank page and try to apply the same settings, then compare what you have done differently in this visual.


Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

amon151
Frequent Visitor

Thanks for the suggestion Fowmy! 

 

When rebuilding it from scratch, I turned off the gridlines before adding the small multiples and voila!

amon151_0-1704830808438.png

 

@amon151 

Glad it worked, You may accept my solution if it was helpful for you.

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.