Forum Discussion
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
- amitchandakSuper User
Anonymous , if you change using slicer it will not change the name. You can try calculation group
calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/:Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
measure slicer
https://www.youtube.com/watch?v=b9352Vxuj-M
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern