Adding more gridlines to Axis (without lables)

[BaileyL]

Hello, 

I am a PowerBI Beginner, 

I have this graph but I can't seem to find a setting that adds more gridlines. I don't want to add them individually, instead choose the increments without labels. 

For example, I want gridlines for each day, but without their labels so the graph doesn't become messy. 

Thanks, 

Bailey 

[v-xinruzhu-msft · Accepted solution]

Hi @BaileyL 

Based on your description, you can consider to use line and clustered column chart.

You can refer to the following sample.

Sample data 

Put the date column to x-axis, put the value column to column y-asix and line y-axis in  line and clustered column chart visual.

Then in property of column, set it color to grey(the color you need) then set its transparency to 70%(or you can set it to the transparency you need )  , set the space between categories to 75%.

Then close the data label.

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.