cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
pontushaglund Frequent Visitor
Frequent Visitor

Using FORMAT destroys table/matrix alignment

I have a "varible" measure that uses SWITCH to decide what measure to show in a table. In the case of YoY% versus VTB I want the result to be percentage rather than Whole number with thousand separator. Using the FORMAT everything gets left-aligned in the matrix (and table) visuals rather than right-aligned (which looks a lot better for numbers).

Am I missing something?

 

Thanks in advance,

 

Pontus

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator Eric_Zhang
Moderator

Re: Using FORMAT destroys table/matrix alignment


@pontushaglund wrote:

I have a "varible" measure that uses SWITCH to decide what measure to show in a table. In the case of YoY% versus VTB I want the result to be percentage rather than Whole number with thousand separator. Using the FORMAT everything gets left-aligned in the matrix (and table) visuals rather than right-aligned (which looks a lot better for numbers).

Am I missing something?

 

Thanks in advance,

 

Pontus


@pontushaglund

I think it is all by design. Using FORMAT converts data to text type. text is left-aligned while numbers are right aligned.

View solution in original post

1 REPLY 1
Moderator Eric_Zhang
Moderator

Re: Using FORMAT destroys table/matrix alignment


@pontushaglund wrote:

I have a "varible" measure that uses SWITCH to decide what measure to show in a table. In the case of YoY% versus VTB I want the result to be percentage rather than Whole number with thousand separator. Using the FORMAT everything gets left-aligned in the matrix (and table) visuals rather than right-aligned (which looks a lot better for numbers).

Am I missing something?

 

Thanks in advance,

 

Pontus


@pontushaglund

I think it is all by design. Using FORMAT converts data to text type. text is left-aligned while numbers are right aligned.

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (5,297)