Forum Discussion

Helper I

5 years ago

Solved

dynamic columns with switch

I want to use dynamic columns based on a slicer. I have a dataset with 2 measures (M1_SUM and M2_SUM), 2 correspoding size columns (M1_SIZE and M2_SIZE) and 1 dimension (DIM): DIM M1_SUM M2_SU...

Need Help

amitchandak
5 years ago
avanroij , If you want to change axis/ change un summarized value. You need use bookmarks or unpivot these columns

bookmarks

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

Dynamically change chart axis in Power BI
https://www.youtube.com/watch?v=6jeSIRpjv0M
https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/

amitchandak

Super User

5 years ago

avanroij , If you want to change axis/ change un summarized value. You need use bookmarks or unpivot these columns

bookmarks

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

Dynamically change chart axis in Power BI
https://www.youtube.com/watch?v=6jeSIRpjv0M
https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/

avanroij
Helper I
5 years ago
thanks, the parameter option was the solution for me.

Forum Discussion

dynamic columns with switch

Related content

Dynamic RLS + Slicer Role Switching Issue

Dynamic Column headers

Dynamic Column Name

Dynamic Matrix Column Switch (Week → Period → Date) using Slicer Not Working

Dynamic Variable in Calculated Columns