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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
andrewpirie
Resolver II
Resolver II

Is it possible to partially step the row headers of a matrix?

I have a header field, and two attribute fields that I would like to include as row headers on a matrix.

 

With stepping, the options are either

 

Stepping On:

HEADERTEXT

         ATTRIBUTE1

              ATTRIBUTE2

 

Or 

 

Stepping Off:

HEADERTEXT      ATTRIBUTE1     ATTRIBUTE2

 

 

 

Is it possible to do partial stepping as below, where one of the row headers is stepped and the others aren't?

 

HEADERTEXT

                          ATTRIBUTE1     ATTRIBUTE2

2 REPLIES 2
v-chuncz-msft
Community Support
Community Support

@andrewpirie,

 

Check if a calculated column that concatenates the values helps.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

If I use a calculated column with REPT of a space character to pad it then I can emulate partial stepping, however this requires the matrix field be using Courier New, the only fixed-with font (as far as I am aware), which does not fit well with the company branding.

Partial stepping using a computed columnPartial stepping using a computed column

Do you have any idea how I could do the above without needing to use Courier New?

 

Thanks for the direction@v-chuncz-msft,

Andrew

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

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.