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
bvy
Helper V
Helper V

Restore Formatting in Matrix

So I spent considerable time adjusting and tweaking the formatting of the native matrix visual. I had to go back and change the Measure/Value column from the Average of A to the Average of B. Doing so wiped out every change I made and reverted the formatting back to default. How do I preserve/restore the formatting?  

3 REPLIES 3
v-alq-msft
Community Support
Community Support

Hi, @bvy 

 

You need to set custom format for each measure. By default the format of fields/measure is general. If you want to set the formatting for a field, or measure, you can do it in two different places:


1. Setting the format in the 'Measure tools'

a2.png

 

2. Setting the format in the Model View

a3.png

 

For further information, you may refer to the following link.

Custom Format Fields and Measures in Power BI 

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

amitchandak
Super User
Super User

@bvy , put the calculation of B and A and A in B. and Later rename them.

while renaming you need have one measure renamed differently for some time

 

 

Greg_Deckler
Super User
Super User

@bvy - I am not aware of a way to do that. Ctrl-Z ?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

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.