cancel
Showing results for
Did you mean:
Frequent Visitor

## Re: How to display last three quarters and QTD for current Quarter in Column chart

Hey, I am able to calculate revenue amount dymanically based on slicer selection. But my goal is to have axis in the column chart populated dynamically as well with last four quarters based on maximum period selected in slicer. Tried using calcualted table as well but didnt't work as they are calculated at query refresh time and not dynamically upon selection of slicer.

Thanks

Vijay

Frequent Visitor

## Re: How to display last three quarters and QTD for current Quarter in Column chart

@Ashish_Mathur I have already provided date column in the updated sample and linked revenue table with the same. Please let me know what else you are looking for?

Thanks

Vijay

Super User

## Re: How to display last three quarters and QTD for current Quarter in Column chart

Hi @vijaykvs,

In the revenue table, where is the date column?  I just see a dateindex column but i do not know what to do with it.  There should be a propoer date column in the revenue table.

Frequent Visitor

## Re: How to display last three quarters and QTD for current Quarter in Column chart

As you mentioned Revenue table has DateIndex and it is pointing to MSFiscalYearTable which has actual date column as well. Cant you get it from there?

Thanks

Vijay

Community Support Team

## Re: How to display last three quarters and QTD for current Quarter in Column chart

I've created the measure above. Check it, please.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor

## Re: How to display last three quarters and QTD for current Quarter in Column chart

@v-chuncz-msft Measure will not be helpful as we need to show this information in a bar chart and last four quartes needs to be displayed dynamically in the chart. Dont think we can use measures to populate Axis in charts unless I am missing something.

Thanks

Vijay

Community Support Team

## Re: How to display last three quarters and QTD for current Quarter in Column chart

It works. Just drag that measure to Value.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Member

## Re: How to display last three quarters and QTD for current Quarter in Column chart

Dear @vijaykvs,

We can not make a Dynamic column.

- First: only Measure can refresh data after selected a fiter. So when you make a Dynamic column, it'll show the first value at the firs time data load and won't change.

- Second: Measure can not show as Axix or Legend, it only place in "Value" in chart.

Hope someone can resolve it

Thanks & Regards,

ManNVSM.