Custom Sort x-axis

[Anonymous]

Hi I have tried to find some similar issues but was not successful, so apologies if there is already many threads about this issue.:) I have a running total, which counts created issues pr month, this works fine, however on the chart i cannot split it in years. E.g. i want chart to show only the last 12 month , but still accumulated or only the months in 2017 Note, is it not possible to add pictures`?

[v-yuezhe-msft]

@Anonymous,

How do you create the chart and what formula do you use to create the running total? You can upload screenshots using the button as below.


In my Desktop, I create a running total measure and a calculated column using the DAX below in my sample table.

running total = CALCULATE(SUM(Sheet5[SalesAmount]),FILTER(ALL('Calendar'),'Calendar'[DateKey]<=MAX('Calendar'[DateKey])))
last12month = if(AND(Sheet5[DateKey]>=TODAY()-365,Sheet5[DateKey]<=TODAY()),1,0)

Then create a chart as follows.



Regards,

[Anonymous]

i tried, but cannot get it to work

Do you use the year and month from calendar? 

i tried both from calendar and from the table with

[v-yuezhe-msft · Accepted solution]

---

@Anonymous wrote:

i tried, but cannot get it to work

Do you use the year and month from calendar? 

i tried both from calendar and from the table with

---

@Anonymous,

In your first screenshot, please choose the "Expand all down one level in the hierarchy" button to drill down your chart.


Regards,
Lydia

[Anonymous]

thank you very much, works fine

[Anonymous]

hi 

My running total is like this

Running total = CALCULATE(COUNT('Case Reg'[Case Number]);FILTER(ALLSELECTED('Case Reg');'Case Reg'[Created On].[Date]<=MAX('Case Reg'[Created On].[Date])))

and yes the chart i would like to have shown is just like the one you have posted