Forum Discussion
Formula date and quantity problem
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
3 Replies
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.
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.