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.
@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?
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.
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?
I've created the measure above. Check it, please.
@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.
It works. Just drag that measure to Value.
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,