Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
61 | |
58 |
User | Count |
---|---|
194 | |
111 | |
105 | |
79 | |
71 |