Line Graph Right To left

[Anonymous]

Good afternoon

I have a cumulative graph created using the following Dax expression from "Quick Measures" (By Trading Day & Not Date):

Total Mass running total in Trading Day =
CALCULATE(
[Total Mass],
FILTER(
CALCULATETABLE(
SUMMARIZE(
'Master Bales',
'Master Bales'[Date],
'Master Bales'[Trading Day]
),
ALLSELECTED('Master Bales')
),
ISONORAFTER(
'Master Bales'[Date], MIN('Master Bales'[Date]), DESC,
'Master Bales'[Trading Day], MIN('Master Bales'[Trading Day]), DESC
)
)
)

This measures seems to be working okay in calculating the cumulative values.

However the line graph is going from right to left and not left to right . i.e the X axis starts with the last day and the highest point.

How do I change this so that the line flows from left to right as normal.

The graph also shows all 105 one by one, how can I make the X axis work with intervals of say 5 days?

Thanks

Herbz

[dramus]

In the visualization pallet, change the "Type" to categorical.

Then on the graph click on the elipses (...) in the top right and there will be an option to sort the x-axis.

[Anonymous]

Many thanks dramus

That worked beautifully. On to the last question:

I have 105 days in total and the graph is showing every single one so I have to toggle across. How do I get the graph to show say every 5th day for example?

Many Thanks

Herbz

[v-huizhn-msft]

Hi @Anonymous,

Untill now, we can not set the x-axis custom interval, please see the following ideas and vote them.

Add the axis interval in the charts

Axis with configurable units (/Interval)

Best Regards,
Angelia

[dramus]

Now that, I can't think of a way to do that in the visual. You may need to create a new measure/column t oaccommodate that.