Forum Discussion

kulpowerbi's avatar
kulpowerbi
Icon for Helper I rankHelper I
5 years ago

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

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.

2 Replies