Formula date and quantity problem

[Anonymous]

Hello everyone,

I need to classe something by fiscal year, so I did a formula in power query to date it :

The problem in my report is that when I use an inphographic to show itand filter it, it classes by quantity and not by date, do you know where is the problem ?

Thank you

[Anonymous]

Hi @Anonymous ,

Sorry, not very clear. Could you please provide some sample data and corresponding expected results?

What does it mean that it classes by quantity and not by date?

If you want to classes by quantity, you need to create a field of quantity range for your chart.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

When I filter it, instead of stay chronological, the infographic sort by quantity.

[Anonymous]

Hi @Anonymous ,

If you want to sort the "FY**/**", you can sort it by a column. Please refer to

Custom sort orders in Power BI - Power BI Visuals by Nova Silva

Sort one column by another column in Power BI - Power BI | Microsoft Learn

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.