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 |
---|---|
139 | |
113 | |
103 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |