Forum Discussion

akwang's avatar
akwang
Advocate II
8 years ago
Solved

Remove dates from axis

Hi all, i created a graph with a switch tab that displays 2 sets of totals. When i switch on the first the graph is okay, but in the second tab the graph shows dates that are not included for that se...
Need Help
  • TomMartens's avatar
    TomMartens
    8 years ago

    Hey,

     

    without knowing exactly how your Measures are calculated it's difficult to give you any other advice than "use the date column" from your source table ;-)

     

    Regards

    Tom

TomMartens's avatar
TomMartens
Super User
8 years ago

Hey,

 

I guess you already checked this, but maybe not :-)

 

Have a look at the axis of your visual, but maybe "Show items with no data" is checked as in the screenshot below:

 

Regards

Tom

akwang's avatar
akwang
Advocate II
8 years ago

Hi TomMartens, it is not checked.

  • TomMartens's avatar
    TomMartens
    Super User
    8 years ago

    Hey,

     

    not sure what is going on on your side.

     

    Here you will find a little pbix file, that behaves as expected.

     

    If this gives you no clue, I guess you have to prepare some sample data, that allows to reproduce your issue.

     

    By the way what visual are you using?

     

    Regards

    Tom

    • akwang's avatar
      akwang
      Advocate II
      8 years ago

      Hi TomMartens, I am using the Area Chart, but same also when i select other charts. My Data starts from March 2017, but chart shows from Jan 2017. Could it be since my date table is from Jan 2017?

    • akwang's avatar
      akwang
      Advocate II
      8 years ago

      Hi TomMartens, When i use my date table i get the problem, but when i use the date from the source table it works fine. Any advice?

      • TomMartens's avatar
        TomMartens
        Super User
        8 years ago

        Hey,

         

        without knowing exactly how your Measures are calculated it's difficult to give you any other advice than "use the date column" from your source table ;-)

         

        Regards

        Tom