Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
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?
found the solution in this thread:
@AnetaK,
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?
Regards,
Lydia
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.
@AnetaK,
Could you please share dummy data of your table here so that we can test?
Regards,
Lydia
User | Count |
---|---|
106 | |
86 | |
81 | |
73 | |
71 |
User | Count |
---|---|
112 | |
100 | |
98 | |
72 | |
66 |