Forum Discussion

vnwakoh's avatar
vnwakoh
New Member
8 years ago
Solved

Dynamic/Variable Column Header Names Changing with Slicer

Hello folks,   So I have this query that gives me income per month, as well as columns to show what the last 2 months' income have been. You can see an excerpt of the data below; Period Actual...
Data Modeling
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi vnwakoh,

     

    We are not able to change column headers based on selected slicer visual. To work around the issue, we can optimize data below in Query Editor: 

     

    1. Select [A Month Ago Name] and [2 Months Ago Name] columns then click Unpivot Columns.

    2. Add a conditional column: 

     

    Apply changes and back to report, create a matrix visual: 

     

     

    Best Regards,
    Qiuyun Yu 

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

Hi vnwakoh,

 

We are not able to change column headers based on selected slicer visual. To work around the issue, we can optimize data below in Query Editor: 

 

1. Select [A Month Ago Name] and [2 Months Ago Name] columns then click Unpivot Columns.

2. Add a conditional column: 

 

Apply changes and back to report, create a matrix visual: 

 

 

Best Regards,
Qiuyun Yu 

vnwakoh's avatar
vnwakoh
New Member
8 years ago

Thanks v-qiuyu-msft

 

Let me quickly try this out.

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    8 years ago

    Hi vnwakoh,

     

    Have you tried the workaround in your scenario? Is it working for you? 

     

    Best Regards,
    Qiuyun Yu