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

[vijaykvs]

Hello everyone,

I have a requirement where in a hierarchy slicer with Year/Qtr/Month, user needs multi-select option and in one of the charts, user needs to have Last three Quarters and QTD for current quarter (in total 4 bars) to be shown in a Bar Chart. As there is Multi-Select option on the date slicer, Quartes need to be determined dynamically based on the maximum period selected in the slicer. Please help.

Thanks

Vijay