Forum Discussion

bvy's avatar
bvy
Helper V
6 years ago

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?  

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    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

     

     

  • v-alq-msft's avatar
    v-alq-msft
    Community Support
    6 years ago

    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'

     

    2. Setting the format in the Model View

     

    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.