Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Dynamic column selection based on Slicer selection

If I have a table that has columns:
1. Customer

2. Sum of sales

3. Sum of budget

4. Sales vs Budget

and a Slicer that has a single select option between Budget and Forecast, how can I change the third and fourth column based on the Slicer selection? For example when the Slicer option is on Budget, the table's third column is "Sum of budget" and the fourth column is "Sales vs Budget" and when the Slicer option is on Forecast, the table's third column is "Sum of forecast" and the fourth column is "Sales vs Forecast".

 

Does the solution to this change if the number of options in the Slicer is more than 2?

 

Thank you!

1 Reply