Forum Discussion

KALAKUNTLAS's avatar
KALAKUNTLAS
Frequent Visitor
5 years ago
Solved

Whitespace (indentation) before text

Hi All, I am working on a Table visualization (matrix) and I want to show one main heading and subheadings with the right indentation. I tried by adding space before the text in the format tab. Stil...
Need Help
  • JoaoMarcelino's avatar
    JoaoMarcelino
    4 years ago

    Hi Kalakuntlas,

    Welcome to this amazing community!

    The indentation you are looking for is "out of the box" in a visual such as a matrix.
    The trick is placing in "rows", fields that represent the different levels of hierarchy such as in the example below (it is from Microsoft Dashboard in a Day so I can send it to you if you want).


    MFelix do you have other suggestions you can provide 🙂 ?

    Hope I was of assistance!

    Cheers,
    Joao Marcelino

    Ps- Did I answer your question? Mark my post as a solution! Kudos are also appreciated 🙂

JosHeusdans's avatar
JosHeusdans
New Member
3 years ago

Another option is to add chr(9) and after that the blank spaces.  I've done it in SQL, but I'm sure you can do the same trick in PowerBI.

 

Example:

Concat(
             IIf(Len(T.VolgnummerPath) - Len(Replace(T.VolgnummerPath, '/', '')) > 2,
                 Concat(Char(9),
                 Replicate(' ', Len(T.VolgnummerPath) - Len(Replace(T.VolgnummerPath, '/', '')) - 2)),
                 Null),
                 T.Naam)

 

In a table visual it shows like:

Example