Forum Discussion
Line & Column Chart
Lucy64 Are you using the same field in the Slicer that you using in the Shared Axis of the Chart?
Yes Sean, it is the date field from the date table. On the image I sent you I was using the Year column but I switched it to the date field (same as in the chart) and I get the same result.
Lucy64 What do you get if you create the same Chart in the Sample file you uploaded?
And select the Years as in the picture below? If you can simulate your condition in the sample file - upload it again
In the sample file where I got the measures the line value is working when I filter, I cannot duplicate the errors I have in my dashboard, let me share my file with you here
In this scenario, please make sure the "Show item with no data" for the field on X-Axis is not selected.
Then you can apply visual level filter to filter the empty or 0 values.
Regards,
Hi Simon,
"Show item with no data" is not selected.
When I try to filter on the line value I get Unexpected Error
