Based on Quarter Slicer Column header should be change

[Anonymous]

I am Having Year , Quarter , Month slicer in report and based on that i am preparing matrx visual for few columns 

Slicer Applied in report as below 

Year 

2017 

Quarter 

3

Month 

July

August

Septemeber 

Based on above Slicer appplied in report below column in matrix visual i am showing 

PaidforIn1       PaidForIn2         PaidForIn3

     4                       10                       16

     8                       12                       14

    12                      13                       18

    16                      16                        20

Here Tricky part for me is I need to Changes header for above columns when user select Quarter 3 Then 

'PaidforIn1' Display as 'July' and PaidforIn2' Display as 'August' and PaidforIn3' Display as 'Septemeber ' 

basically i am having 3 column only header i need to change if user select Quarter 3 or other Quarter then those month name should come in heder insted of  PaidforIn1, PaidForIn2, PaidForIn3. Please help me how to achive in Power BI and DAX.

Thanks 

[v-caliao-msft]

@Anonymous,

You need to use a Matrix visual, and then use add you month file to Column. Please refer to the link below to see the details.
https://docs.microsoft.com/en-us/power-bi/desktop-matrix-visual

Regards,

Charlie Liao

[Anonymous]

@v-caliao-msft,

Thanks for reply but i want header based on dynamic way , suggestion you provide it is not dynamic header genration.

[v-caliao-msft · Accepted solution]

@Anonymous,

The column header is dynamic bu using a matrix.

If this is not what you want, please provide us more information about your report, so that we can make further analysis. You can upload a pbix file to Onedrive or any web storage and share the link. Do mask sensitive data before uploading.

Regards,
Charlie Liao