Forum Discussion

TrentS's avatar
TrentS
Helper IV
7 years ago
Solved

X-axis gridline option

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

Need Help

4 Replies

    • TrentS's avatar
      TrentS
      Helper IV
      7 years ago

      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