I am looking for advice on how to use this fair simple Parent Child dimension.
|A00081||BANK SCF SUB A||A00080|
|A00082||BANK SCF SUB B||A00080|
I would require to have a slicer with typical Behavior, if filtering ALL Operations , all member displayed, and for example if selected sum all accounts of children from A00049 BANK SANGLOB
It could be good to have any tabular graph, for slicing and drill/ down like pivot table / matrix but not sure how to do this with powerbi.
At least filtering and getting children from a member should be a must
I have used Drill down on visuals when I have several fields ( Continent--> country --> State).
but how Can i configure it with my current tables, can you please assist me initial steps.
I haven't see it on this blogs ! thanks
After my research, Drill down function is not supported in table visual for now, and you use drill down function
in maritx visual.
and you do these follow my steps like below:
drag the hierarchy fields into Rows or Columns together.
click one of these two icons to drill down next hierarchy。
And if you want to use Drill down on table visual, you could post your new idea in Power BI ideas and make this feature coming sooner.
Your solution is valid for a fixed hierarchy with several columns like Continent--> Country --> State
However my business case is with a Parent child
Check screenshot, I only have column with Entity ID and other with Parent Entity ID.
And I would want to collapse , expand drill like textbox on below text box ( imagine a dynamic table of excel with collapse expand)
After my research, you may try to do these as below:
use SEARCH Function to add a Parent-child hierarchy
hierarchy = IF ( SEARCH ( "BANK SANGLOB", Table1[Name], 1, 0 ) > 0, "BANK SANGLOB", IF ( SEARCH ( "BANK SCF", Table1[Name], 1, 0 ) > 0, "BANK SCF", IF ( SEARCH ( "BANK BBGLOB", Table1[Name], 1, 0 ) > 0, "BANK BBGLOB", IF ( SEARCH ( "BANK XXGLOB", Table1[Name], 1, 0 ) > 0, "BANK XXGLOB" ) ) ) )
Import custom slicer from Marketplace
Parent-child hierarchy fields into slicer like this:
By the way, you need not add ALL OPERATIONS in the column Name, if you don't select any value from slicer,
it will show all the data, So you may remove the first row.
here is pbix, please try it.
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.
Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.