Forum Discussion
x Axis does not adjust to filtered data
Hello everyone, On a report page I have several "Line and clustered column charts" with sales on the y axis and weeks on x axis. (weekly sales as lines and YTD as bars) I have report filters:...
Fowmy
Super User
Super UserAnonymous
You can apply a condition to your measure that you use it the chart to check if there a value to display otherwise show blank which will hide as you desire.
New Measure =
IF( ISBLANK([YOURMEASURE]), BLANK(), [YOURMEASURE])
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
Hi Fowmy,
thanks for the quick reply. I just tried your suggestion. Strangely it just works when I set x<15 in the relative date filter for the page "is in the last x calendar weeks" .