Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
rbhattacharya
Helper I
Helper I

Add leading spaces to create indentation effect for matrix visual

Hello,

 

Is there any way to add leading space(s) before a measure name in matrix visual? I'm trying to replicate a excel sheet as shown below using matrix visual. Kindly suggest.

 

Thanks,

RB

 

Capture.JPG

1 ACCEPTED SOLUTION
v-alq-msft
Community Support
Community Support

Hi, @rbhattacharya 

 

I'd like to suggest you go to 'Visualizations'=>'Format'=>'Values'=>make 'Word wrap' off. I created data to reproduce your scenario.

Table:

a1.png

 

Measure:

Measure = "        "&MAX('Table'[Name])

 

When 'Word wrap' is on:

a2.png

 

When 'Word wrap' is off:

a3.png

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-alq-msft
Community Support
Community Support

Hi, @rbhattacharya 

 

I'd like to suggest you go to 'Visualizations'=>'Format'=>'Values'=>make 'Word wrap' off. I created data to reproduce your scenario.

Table:

a1.png

 

Measure:

Measure = "        "&MAX('Table'[Name])

 

When 'Word wrap' is on:

a2.png

 

When 'Word wrap' is off:

a3.png

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

aj1973
Community Champion
Community Champion

Hi @rbhattacharya 

I had that issue as well so i filled up the space by * instead like here

aj1973_0-1610485190038.png

 

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.