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.
I have an issue with drilling down the Metrix table "Go to the next level in the hierarchy (button)" is not making any sense to me as per my data.
Here is how my Data looks like.
Here is the default result of my Matrix Table.
Here is the level 1 result of hierarchy.
Here is the level 2 result of hierarchy.
Here is the level 3 result of hierarchy.
By using "Go to the next level in the hierarchy (Button)" its simply adding up all the values by year, month and day as per our data I want to drill down using "Config" column as primary.
eg.
Level 1
config 1
Year 2016 all values
Year 2017 all values
Level 2
config 1
Year 2016
Month August all values
Month December all values
Year 2017
Month August all values
Month December all values
Level 3
config 1
Year 2016
Month August
Day 1 all values
Day 2 all values
Month December
Day 1 all values
Day 2 all values
Year 2017
Month August
Day 1 all values
Day 2 all values
Month December
Day 1 all values
Day 2 all values
So on config 2,3,4,5,6,7,8,9,10
Previously I Posted a Question regarding disable a "Go to the next level in the hierarchy (Button)" or remove, as per the answer I received it is builtin functionality it cant be removed or disabled.
Here is the Matrix table "Expand all down one level in the hierarchy (Button)" and it's really serving my purpose perfectly.
Is there any way I can drill down using "Go to the next level in the hierarchy (Button)" and I can achieve the same result as
"Expand all down one level in the hierarchy (Button)". or if you have any other suggestion I will really appreciate that.
Solved! Go to Solution.
Hi @joyo,
It is impossible to use this button to achieve the 'expand to next hierarchy level' feature.
AFAK, these button has fixed features, you can only click on 'expand all down one level in the hierarchy ' button to expand records or right click on category column and choose the 'expand to next level' option.
Regards,
Xiaoxin Sheng
Hi @joyo,
It is impossible to use this button to achieve the 'expand to next hierarchy level' feature.
AFAK, these button has fixed features, you can only click on 'expand all down one level in the hierarchy ' button to expand records or right click on category column and choose the 'expand to next level' option.
Regards,
Xiaoxin Sheng
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |