Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
amthorpe2000
Regular Visitor

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 4
amthorpe2000
Regular Visitor

don't have any of the preview options shown in the first link. and company block youtube

Dhairya
Solution Supplier
Solution Supplier

Hey @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.

Dhairya_0-1690520808682.png

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

amitchandak
Super User
Super User

@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-fc4095ae9af...
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-517aacc23fdf

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors