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.

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

Thanks for the trick... I hope it is scalable for years to come (what will happen when a new year that wasn't fixed is added to the table?)

 

I guess I will have to wait and see 🙂

 

Rodrigo