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 set of totals. Any ideas how i can fix? I tried using ISBLANK function but still no help. Thanks.Tab 1Tab 2Switch DAX

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

6 Replies

  • 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

      • 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