Forum Discussion
Help How to remove from a continuous chart empty date
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
8 Replies
Falongi_82 , You have to use the categorical axis type. because in continuous it show dates is blank too, so no way to avoid
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
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.
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.
Fabri, the Categorical option seems to work with your request...
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.
SO, I need to conclude that no workaround are possible ?
Impossible to avoid this?
Thx,Fabri
I haven't found a workaround to avoid this either.
