Forum Discussion

calloni's avatar
calloni
Icon for Helper I rankHelper I
2 years ago
Solved

Fixed Width column based on largest Label

Hello,   I am trying to reproduce this easy to build Tableau Chart in Power BI but it is harder than it looks:     The closest that I got is this using the Matrix visual:     The ...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi calloni 
    Matrix is the way 🙂
    According to the columns width,
    to "freeze" them, you can apply these steps:
    1. Create a measure 

    rep = REPT("X",9)
    9 is the length of the longest string ("problem")+2
    2. grab it to the values :

    3. switch the values to rows:

    4. switch on auto size column width

    5. 4. switch off auto size column width

    6. remove rep measure

    Result :

     

    According to the responsivity of the matrix, you should plan the maximum width +/-, there are no other solutions

     

    pbix is attached

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

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
2 years ago

Hi calloni 
Matrix is the way 🙂
According to the columns width,
to "freeze" them, you can apply these steps:
1. Create a measure 

rep = REPT("X",9)
9 is the length of the longest string ("problem")+2
2. grab it to the values :

3. switch the values to rows:

4. switch on auto size column width

5. 4. switch off auto size column width

6. remove rep measure

Result :

 

According to the responsivity of the matrix, you should plan the maximum width +/-, there are no other solutions

 

pbix is attached

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