Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |