I had to comment because I feel its unfair such a great video remains unnoticed. It was very well explained each detail of the topic, thanks a lot for the effort.
This only works if you do not show other columns.. as soon as I try to add other columns, the blank rows come back. As an example, let's say i wanted to show a currency type for each division in your example. The results will be that the blank rows come back... do you have a solution that can hide the rows despite other columns being available? I tried a visual filter, but seems once i set that, the results are even more unexpected where rows are being hidden when they should not be.
Is it ideal to have the data source already assigned the parent-child relationship between hierarchies? Additionally, if another data is added in-between a path, how would I be able to adjust the hierarchy ranking?
I got error when setting sorting each level. I created new column of Index for each level. Error showed about more than one value relation. Do you know how to fix it?
what to do with the error that all parent values must be in id values. and the first id cannot have it because it has no parent. For me the Path function doesn't work otherwise, for you it surprisingly works ((
Level1 = VAR LevelNumber = 1 VAR LevelKey = PATHITEM(YOURTABLE[PATH COLUMN], LevelNumber, INTEGER) VAR LevelName = LOOKUPVALUE(YOURTABLE[NAME], YOURTABLE[ID], LevelKey) VAR Result = LevelName RETURN Result
How you only have 15 views by now is a mystery to me. Great teaching skills, great tutorial
Great video...thank you!
thank you!
I had to comment because I feel its unfair such a great video remains unnoticed. It was very well explained each detail of the topic, thanks a lot for the effort.
thanks man!
Thank you for taking the time to both explain the type of heirarchy involved and how to show it in PBI. Much appreciated tutorial! 😊
It is very easy to follow. Excellent presentation! You are the best!
glorious thanks!
This is exactly I have been looking for, thank you very much!!
Unbelievably good explantion!!! Excellent, keep up the great work man!
thanks man!
This is a well explained video. Glad I stumbled upon this.
Best Parent Hierarchy Tutorial 👍👍👍
This only works if you do not show other columns.. as soon as I try to add other columns, the blank rows come back. As an example, let's say i wanted to show a currency type for each division in your example. The results will be that the blank rows come back... do you have a solution that can hide the rows despite other columns being available? I tried a visual filter, but seems once i set that, the results are even more unexpected where rows are being hidden when they should not be.
Дякую, дуже допомогли
Great Video..
Is it ideal to have the data source already assigned the parent-child relationship between hierarchies? Additionally, if another data is added in-between a path, how would I be able to adjust the hierarchy ranking?
Great video!!!
How was the TotalAmount Measure created?
That's excellent.
Hi! How was the total amount measure created ? Total amount 2 refers to it
Amazing stuff
I got error when setting sorting each level. I created new column of Index for each level. Error showed about more than one value relation. Do you know how to fix it?
Sir I have a hierarchy of three levels but the sum of lowest level is accurate but it is adding some values from blank to other higher levels
Brilliant!
Hi I don't know how many levels will I have so can I not create hierarchy such that it takes in all column with name starting with level
what to do with the error that all parent values must be in id values.
and the first id cannot have it because it has no parent.
For me the Path function doesn't work otherwise, for you it surprisingly works ((
you are amazig
Level1 =
VAR LevelNumber = 1
VAR LevelKey = PATHITEM(YOURTABLE[PATH COLUMN], LevelNumber, INTEGER)
VAR LevelName = LOOKUPVALUE(YOURTABLE[NAME], YOURTABLE[ID], LevelKey)
VAR Result = LevelName
RETURN
Result