plot date for year and quarter without add up all values

[PeterChen]

Hi, 

I have a data and want to plot the line chart with year and quarter on x-axis.

There is a column called "date".

I create a measure and want to plot this measure.

REALWANT = 
VAR MINYR = CALCULATE(MIN(dt[date].[Year]),ALLEXCEPT(dt,dt[Group])) 
VAR MINQR = CALCULATE(MIN(dt[date].[QuarterNo]),ALLEXCEPT(dt,dt[Group])) 
VAR NEW= CALCULATE(SUM(dt[Numbers]), FILTER(ALLEXCEPT(dt,dt[Group]), dt[date].[Year] = MINYR && dt[date].[QuarterNo] = MINQR)) 
VAR WANTDenominator = IF(MAX(dt[Numbers]) = Blank(), Blank(), [NEW]) 
VAR WANTNominator = CALCULATE(SUM(dt[Numbers]), ALLEXCEPT(dt,dt[Group],dt[date].[Year],dt[date].[QuarterNo])) 
Return
WANTNominator/WANTDenominator 

Now, I click on the Line Chart in the report tab and put this measure on y-axis, Group on legend, and date hierarchy (only year and quarter) on x-axis.

However, the line plot showd inappropriately. On the x-axis, it only showed year so that it automatically added up measure for all quarters in each year by group.

Even I create a new column as below:

yq = dt[date].[Year] & dt[date].[QuarterNo]

And plot again, the x-axis on plot displays weired. It did not display as order.

How can I figure out this?

Also, is it possible to create a filter for Group and when I filter values in that, the plot will change. I think I need to add something like SELECTEDVALUE. Not sure.

[v-frfei-msft · Accepted solution]

Hi @PeterChen ,

Based on my test, I got this output, Then what is your excepted result?

[PeterChen]

---

@v-frfei-msft wrote:

Hi @PeterChen ,

Based on my test, I got this output, Then what is your excepted result?

---

The order is weird if I create a new column with year and quarter.

Moreover, if I plot like your way using original date column and select hierarchy for year and quarter, the x-axis on line chart only shows year rather year and quarter.

In addition, if I copy your plot and then change the axis, legend, and values to my data, it works. Not sure why it works in copy and paste....