Line chart showing beginning of quarter values

[sloane]

Hi Everyone, 

I have a line chart with year and quarter on one axis, and running total on another axis, but the axis for amount only shows the respective amounts for the beginning of the quarter, any ideas how to make this show the end of quarter values? 

Any help would be greatly appreciated!

(unfortunately, I have no sample data or images for this question due to data privacy restictions )

[v-eqin-msft]

Hi @sloane ,

According to my understand, you want to use the last month of each quarter like March,June ,September and December as X-axis,right?

You could create a new group or use  SWITCH( )formula.

Here is my pbix file.

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

Best Regards,
Eyelyn Qin

[Anonymous · Accepted solution]

Hello

On my side, if I use:

- a date table with a quarter column that has the code QUARTER( Date[Date] )

- a current total measure

Sales RT = 
CALCULATE(
    [Sales Amount],
    DATESYTD( 'Date'[Date] )
)

Next, I get the following result:

I hope it helps. Really?

Best

Thomas

[amitchandak]

@sloane , If you have Year and Qtr only, what do mean by beginning and end of qtr