Forum Discussion
Change Field but Retain Format
Hi
We have created some dashboards (tables, charts, cards etc) for scope A and now want to do the same for scope B. We have similar field names in Both A and B and both are in a single data set.
How can we change the existing visual field to the new one without having to go through the lengthy and tedious process of reformatting/conditional formatting the new data.
E.g. A donut with Male/Female we want to duplicate the sheet and change Male to Dog and Female to Cat.
It seems mainly to apply to tables but have noticed it with others
4 Replies
amthorpe2000 , You should have used a field parameter for that
Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd
Power BI Field Parameters- 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-517aacc23fdfHey amthorpe2000
If you want two separate visuals with the same visual formatting then you can use the format painter button and copy-paste formatting from one visual to another, but conditionally formatting applied on fields will not be retained, that you have to configure manually.
or else you can plot one visual and create the field parameter which can help you to switch between two different measures using the slicer. You can refer to mentioned video for the same.
https://www.youtube.com/watch?v=-nqEv2YXLsU&ab_channel=HowtoPowerBI
If this helps you then please mark my solution as accepted so that others can find it quickly while facing a similar issue. Thank You!format painter dosen't seem to do anything
don't have any of the preview options shown in the first link. and company block youtube
