Search code examples
ssasssas-tabular

Changing color in a measure in SSAS

I have a Measure, created in SSAS for one of the tables -

      Total Hours:=SUM(Timesheets[Hours])

Is there a way to make this measure Red color or in Larger font?

So it would be different from the other existing Measures

Thank you!

Solution

  • There is no way to decorate measures and other model metadata within a Tabular or Power BI model, so that they appear in a special way within client tool. Your best options are:

    • Naming: Most client tools order the measures alphabetically, so if you have an important measure you want to show at the top of the list, make sure that it starts with some letter, punctuation or number, so that it will be sorted at the top of list.
    • Display Folders: You could consider moving all measures, except the "important" ones, into a Display Folder.