I have a dashboard in which I have to place around 24 calculated fields (numbers) (with the same filters). The way I am able to understand how to do this is by creating a separate worksheet for each of these numbers. Is there a better way to do this?
Also, if there is, is there a way to format some of these differently, but again efficiently?
individual sheets will give you more control on formatting (especially in elements like color or shape) & positioning on a dashboard. Alternatively you can use measure names & measure values to show several metrics on the same sheet. Number formatting can still be kept as show below.
Hope that helps!