dynamic column header/data based on Year Quarter and month selected in slicer

[kulpowerbi]

I have 3 columns: 

date, Location, Sales. Here is sample data.

I want to populate a table visual for Location-wise total sales based on slicer selection, where I would like to add a date hierarchy slicer (Year/Qtr/Month). and Table visual should filter based on that slicer.

Column Header should change based on slicer selection like in the below scenario:

Suppose is Year selected 2020 then the column header will show (2020 Sales).

If further Qtr1 is selected under 2020, then the column header will show (2020-Q1 Sales)

if further Month Name (Apr) is selected, then column header will show (2020-Q1-Apr Sales).

Thank you in Advance.

[kulpowerbi]

@amitchandak  I want to add a YTD column as well which should not change based on the slicer. is it possible to have two columns (measures) one is for the selected month and another is for YTD?

[amitchandak]

@kulpowerbi , you can not change the measure header. But you can give dynamic title to visual

refer

https://www.youtube.com/watch?v=TYLKDPcvgK8
https://www.blue-granite.com/blog/create-a-dynamic-title-in-power-bi-updated