Guidance on creating a switch view in Power BI

[Kunal_Chandak]

Hi,

I have a visualition in place where I have 4 widgets on 1 app and have multiple such apps on my dashboard. My current basic tables are as follows

Account Name / Industry / BU - NSR - PY NSR - Growth % (calculated field) and a few more columns.

Now I want to create a functionality where NSR, PY NSR, Growth %  are replaced by Engagement NSR, Engagement PY NSR and Engagement Growth % values resp.

I have searched for the possible ways and explored
1. Bookmark and button
2. Parameter function
3. Dynamic Slicers

can be used. My data is huge and I am also concerned about performance. Can you suggest the best or alternative way to do this?

[Kunal_Chandak]

Hey @amitchandak , 

Thanks for the help. I have created a table for the Value columns to get the Dynamic Slicers and used the steps for measures to get the swap columns.

[amitchandak]

@Kunal_Chandak , If Field Parameters is working that is best option for both measures and Axis Slicer,

Another option for measure slicer is calculation groups followed by Dynmic slicer using Disconnected tables

For Axis Slicer best option after field parameters is Bookmarks

Field Parameters
A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Field Parameters- Conditional Formatting
: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf
Field Parameters, Keep Axis Sort intact| Always Sort on X/Categorial Axis: https://youtu.be/GfBrB6czByw

[Kunal_Chandak]

Hello @amitchandak, 

Thanks for the help and sharing the resources. 

They are very helpful and insightful. Just a quick doubt, I have tables whereas in your resource I can't see any preexisted tables. I am attaching a image of one below for reference. Can we use create the toggle using measure and get those NSR ,PY NSR and Growth % columns changed based on the information you shared?

 

[amitchandak · Accepted solution]

@Kunal_Chandak , Based on what I got, if you want a set of measures to change based on the selected axis - Changing measures based on the axis with Field Parameters in Power BI. Dynamic measures based on the axis/Dimension: https://youtu.be/7ikRAelDph0

Hope this can help