X-axis gridline option

[TrentS]

Hi all,

I have a line and stacked column chart that I need to replicate on another tab. I am getting different options after I copy the visual over to the new tab and change the values (which are all calculated measures). The axis is the exact same date table in QTR/Month/Week fashion on both. When moving down the hierarchy I should see each month listed and then the quarter down below, once. Instead, the new table displays 2019Q3July 2019 style for each point. All fields used are set to dates or numerical counts in the case of the measures.

In the copied chart, it does not have the 'Show Gridlines' option that the original chart does. I saw some other posts indicating that this may be due to field type settings but I am using the same fields on both from the Date table.

Why is the gridline option missing and how do I get to the "cleaner" looking hierarchy (if its not the gridline option causing the issue)?

TrentS

[Anonymous]

HI @TrentS ,

Can you please share a pbix file with sample data to test? 

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

[TrentS]

Hi Xiaoxin,

Can't do the pbix but I can do screenshots to illustrate the issue.

Here are the x-axis in both correct (single Quarter name listed below with separating gridlines) and the incorrect copied visual. Creating a new visual of the same type yields the same results, no gridline option.

Here is also a shot of the x-axis settings showing the Gridline settings and options from the visual showing it correctly. The other visual does not have any gridline option at all.

Trent

Correct

Incorrect

[Anonymous · Accepted solution]

Hi @TrentS ,

Have you setting 'sort by' field on second visual? It seems like you need to apply 'order filed' to enable hierarchy label layout.

How to split X-axis data labels into two lines

Regards,

Xiaoxin Sheng

[TrentS]

Hi Xiaoxin,

Thank you. That seems to solve the situation. Odd since I did not select any specific sorting on the first one and secondarily, that the format painter did not carry it over nor the direct 'Copy visual'.

Since it was sorting the axis chronologically already, I didn't think to address it again.

Well called!

Trent