Help How to remove from a continuous chart empty date

[Falongi_82]

Hello All,
Need your help to remove from a continuous line and staked column chart, date with no value.
If I put these same data selection in mode categorical, the problem does not occur !

Same fields are selected to generate the 2 graphs :

I've a slicer based on a "picking date" from my table Q_SAP_LINES_BY_FLOW

and this picking date is linked to the field "date" from a calendar table 

Thx in advance for your help,

Fabri

[Falongi_82]

SO, I need to conclude that no workaround are possible ?

Impossible to avoid this?

Thx,Fabri

[v-jingzhang]

I haven't found a workaround to avoid this either.

[Falongi_82]

Hi @amitchandak ,

My clients want to have a continuous global view and to be able to filter over well defined periods of time.

From this screen :

to this (after apllied filter) :

Thx,

R/

F.

[AliceW]

Fabri, the Categorical option seems to work with your request...

[Falongi_82]

Yes, I know but I don't want to have to scroll 😉 and have a long graph.

that's why, I'm trying to find a solution with the continuous graph that give a global without scroll axis bar.

F.

[AliceW]

Hi Fabri,

Have you unchecked 'Show Items with no Data'? It will hide the margins, but not all dates.. I don't think it's possible when 'Continuous' is there.

Alice

[Falongi_82]

Hi Alice,

Yes unchecked 🙂 to have a continuous graph, I work without date hierarchy

thx to have tacked time to try to help me

F.

[amitchandak]

@Falongi_82 , You have to use the categorical axis type. because in continuous it show dates is blank too, so no way to avoid