1 Reply Latest reply on Dec 22, 2018 5:08 AM by Michael Gillespie

    Formatting multiple measures with one action

    Matt1337
    Matt1337 Dec 22, 2018 4:17 AM

      Hello,

      I have a workbook where there are around 30 measures in a view. I would like to change all of the measures formating from a number format to a currency format. IS there a way to make this with a one single "click"? or do i have to change format of all measures seperatly ( 30 times change formating of each measure)?

        • 1. Re: Formatting multiple measures with one action
          Michael Gillespie
          Michael Gillespie Dec 22, 2018 5:08 AM (in response to Matt1337)

          Fastest way: In the Measures pane (NOT on the viz or dashboard) CTRL-LEFT CLICK (Option-Click on Mac, I think) to select all the measures you want to change.  Right-click on that selection and select Default Properties, Number Format.  You can change them all at once.

           

          You could also pivot your source data so that all your measures are in one column, then format that one column the way you want.  But that will break any vizzes built with the measures as separate columns.

          1 of 1 people found this helpful