Timeseries with a dynamic legend that depends on slicer choices based on parent/child hierarchy

[shmooel]

So, I have a dataset with multiple hierarchies (I only provide 3 below as an example but it's more). I want to be able to create a timeseries where if you select something from a Tier it shows all the Children in the Legend or a line for each one and averages the values for those children.

So, the x-axis are the dates and the y axis is the average of the values but I can't get the Legend to dynamically shift down to the children relating to that hierarchy. I feel like it somehow combines parameters but just can't seem to get the last bit. I don't want the user to have to select Tier1 or Tier2 but instead because they filtered down to an entity in Tier1 it shows only the related entities in Tier2 in the legend and thus a line for each one; repeat for each hierarchy. When no hierarchy is selected it should show a line for each distinct Tier1 entity.

I feel like the next step is sort of this video but I'm having trouble crossing the finish line with it: https://youtu.be/KReYWx5NXYg

Tier1	Tier2	Tier3	1/1/2023	1/2/2023	1/3/2023	1/4/2023	1/5/2023	1/6/2023	1/7/2023	1/8/2023
TOPA	MIDA	BOT1	5	40	36	42	8	36	18	16
TOPA	MIDA	BOT2	47	5	26	23	29	9	1	19
TOPA	MIDA	BOT3	14	19	18	9	27	29	35	22
TOPA	MIDB	BOT1	33	0	27	23	29	20	23	8
TOPA	MIDB	BOT2	31	24	26	12	32	18	2	14
TOPA	MIDB	BOT3	18	10	36	41	20	22	35	29
TOPB	MIDA	BOT1	47	25	6	44	48	42	43	43
TOPB	MIDA	BOTA	21	15	49	11	20	37	28	10
TOPB	MIDC	BOTD	8	25	4	29	8	39	2	29
TOPB	MIDC	BOTB	14	16	38	15	41	43	28	32
TOPB	MIDB	BOT2	25	14	27	48	28	7	39	29
TOPB	MIDB	BOT5	48	50	39	11	32	10	19	47
TOPB	MIDB	BOT7	6	3	50	36	4	36	7	49
TOPC	MIDD	BOTT	15	42	27	34	1	13	36	42
TOPC	MIDD	BOTO	11	40	10	41	33	4	33	14
TOPC	MIDD	BOTP	3	23	33	32	10	44	40	13
TOPC	MIDD	BOT3	18	9	34	29	6	39	41	0

[amitchandak]

@shmooel , Not very clear. If you want switch legend field parameter can help, Also you should able switch measure with the legend

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f

Or you can switch measure using isinscope

IsInScope - Switch Rank at different levels: https://youtu.be/kh0gezKICEM

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.