Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am trying to create a line graph between months of Fiscal date and sales. Now my fiscal date actually starts from October, so on the x axis of my line graph I want the months to start from October and not January. Is there any way to do that?
Solved! Go to Solution.
you'll need to add an order calculated column into the table with the dates.
typically in our dates table we have a Month of Year Column which holds a 1 for january, 2 for Feb etc...
if you have this you can then add a calc column to store the order.
=if([Month Of Year]-9<=0,[Month Of Year]+12-9,[Month Of Year]-9)
you can then set the order by column on any referenced date columns (so your fiscal date column) to newly created order by column.
I hope that makes sense.
you'll need to add an order calculated column into the table with the dates.
typically in our dates table we have a Month of Year Column which holds a 1 for january, 2 for Feb etc...
if you have this you can then add a calc column to store the order.
=if([Month Of Year]-9<=0,[Month Of Year]+12-9,[Month Of Year]-9)
you can then set the order by column on any referenced date columns (so your fiscal date column) to newly created order by column.
I hope that makes sense.