cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
AnetaK Member
Member

Line chart date axis not filtering

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?

 

Przechwytywanie.PNGPrzechwytywanie2.PNG

 

3 REPLIES 3
Moderator v-yuezhe-msft
Moderator

Re: Line chart date axis not filtering

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
AnetaK Member
Member

Re: Line chart date axis not filtering

Przechwytywanie3.PNG

 

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.

Moderator v-yuezhe-msft
Moderator

Re: Line chart date axis not filtering

@AnetaK,

Could you please share dummy data of your table here so that we can test?

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.