Forum Discussion
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. Still, powerBI doesn't take space. The below image shows the powerBI format and the right side image shows what I actually want. It would be great if you could help me solving this issue.
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 MarcelinoPs- Did I answer your question? Mark my post as a solution! Kudos are also appreciated 🙂
8 Replies
- JoaoMarcelino
Responsive Resident
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 MarcelinoPs- Did I answer your question? Mark my post as a solution! Kudos are also appreciated 🙂
- MFelix
Super User
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] ) )You can also make some twikings so the values don't appear duplicated on the bottom levels. but this is my main toughts.
Check PBIX attach.
Thank you, MFelix. I didn't learn the DAX language yet. But, I will use this as future reference.
Thank you, Jao. I agree it is out of the box. This solution is something close to what I am looking for.
- JoaoMarcelino
Hi KALAKUNTLAS,
I'm happy we helped, if my answer was a solution to your question, please consider marking it as "Solution" to better help other members in the future 🙂
Cheers,
Joao Marcelino
sharmon9000Helper I
I know this is a late reply, but for anyone searching for workaround to this, just insert a blank Braille block character and in PowerBI it looks like a space. Just copy the space between the following quotes and paste it into your report and PowerBI shows a space. "â €"
Link to where I found this
WaterHelper II
Surprisingly effective, thank you!
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
