Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |