cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vijaykvs Frequent Visitor
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

vijaykvs Frequent Visitor
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
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.

vijaykvs Frequent Visitor
Frequent Visitor

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

Hi @Ashish_Mathur 

 

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
Community Support Team

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

@vijaykvs,

 

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.
vijaykvs Frequent Visitor
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
Community Support Team

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

@vijaykvs,

 

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.
ManNVSM Member
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 Smiley Happy

 

Thanks & Regards,

ManNVSM.

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 134 members 1,720 guests
Please welcome our newest community members: