Need your help. For some reason, there is no space b/w dimension value and bars of the chart in my bar chart for a specific dimension that I am calculating to sort the fiscal period/quarter. They (values and bars/scroll) are overlapping.
It works for other dimensions fine.
FYI Load Scrip snippet:
Trim(Mid([Fiscal Period],4)&' - '&Mid([Fiscal Period],2,1)&'Q') as [Fiscal Period Sorted],
What is wronge here? Any idea on how to fix it or best practice to achive it without creating issue?