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
5 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 🙂

MFelix

Super User

5 years ago

Hi KALAKUNTLAS ,

I agree with JoaoMarcelino and that is the best option however what I think you are missing is the second level of the hierarchy to get the advance to work.

Having this said, believe that what you are using on your visualization are meausures or aggregations of columns is this assumption correct?

If so the creation of the level needs to be done in a different way:

If using colum aggregations or measures and don't want to change the input values what you can do is to add some dots to have the split
Another option requires the creation of an additional table and some DAX measure to make it happen.

In the second case you need to had a table with your measures names and the groupings:

Aggregation Measure

Average value 1	Average value 1
Value2	Min of value 2.1

Dax measure:

Calculation Matrix =
SWITCH (
    TRUE (),
    SELECTEDVALUE ( neasuretable[Measure] ) = "Average value 1", AVERAGE ( 'Table'[value 1] ),
    NOT ( ISINSCOPE ( neasuretable[Measure] ) )
        && SELECTEDVALUE ( neasuretable[Aggregation] ) = "Value2", SUM ( 'Table'[value 2] ),
    SELECTEDVALUE ( neasuretable[Measure] ) = "Min of value 2.1", MIN ( 'Table'[value 2.1] )
)