I have a line chart showing a measure.
After filtering the date the data changes but there is no change on the axis.
I would like it to dynamicly reflect the filter.
What should I change?
Are the Fiscal Year field and Date field in a same table? Could you please share sample data of your table here? And what data would you like to show in X-Axis when you set Fiscal Year to 2018/2019?
It is a measure calculating errors in orders.
We want to show the good ones, so it is 1-error%.
Measure% = 1-DIVIDE([NumberOfErrors],Orders[TotalOrders],0)
On the X axis we should see dates from April 2018 as the a new FY begins.
Now we can see from January 2017 to the end of 2018.
Could you please share dummy data of your table here so that we can test?