Klemen's Blog

kl82slo.github.io

MicroStrategy Format multiple metrics

14 Feb 2024

Dificulty ★☆☆☆☆

INTRO

Sometimes you need to format multiple metrics and you don’t want to do it one at the time

How to use ‘Find and Replace’ tool


Go to ‘Tools’ and then ‘Find and Replace’
Partition Table

Change category to ‘Metric Formating’
Metric formating

In find select what metrics do you want to change
Metric Select

Click ‘Update Summary’
Update Summary
The list of selected metrics will be shown

Then select that you will only change Metric Values and set formating.
Metric Format Fixed

And finaly click ‘Replace’
Metric Final