I have tried the above 2. Also in the measure, I have tried if condition as If (count(xyz) >0 ,count(xyz),0) it is also not working.
NOTE: "Time" Dimension is the joining key across 4 tables.
Above Snapshot is for a filter (Like RED Shirts) as mentioned in the original Question.
have you tried this?
Do the following:
- In sheet view, click @Edit in the toolbar.
- Click the line chart that you want to edit.
- In the properties panel, click the Appearance tab.
- In the X-axis section, check Use continuous scale.The chart is compressed and the data points and labels are readjusted.