Reply
Frequent Visitor
Posts: 6
Registered: ‎08-28-2017
Accepted Solution

Formating measure result

Hi,

 

I'm creating an YOY measure which i would like to show in percentage and all the solutions I've found on forum are for excel uploaded data. I'm getting my data through SQL Server Analysis Services database so i can't just open the table and format the column. 

 

Is there any other way I can format it, maybe a measure calculation to show %?

 

Thank you

 


Accepted Solutions
Member
Posts: 129
Registered: ‎07-26-2017

Re: Formating measure result

[ Edited ]

Hi @acute,

 

You can change format via:

 

Untitled.png

 

Also in query mode you can set needed format or you can use formula format().

View solution in original post


All Replies
Member
Posts: 129
Registered: ‎07-26-2017

Re: Formating measure result

[ Edited ]

Hi @acute,

 

You can change format via:

 

Untitled.png

 

Also in query mode you can set needed format or you can use formula format().