Remove dates from axis

[akwang]

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

[TomMartens]

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]

Hi @TomMartens, it is not checked.

[TomMartens]

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]

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 · Accepted solution]

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

[akwang]

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?