The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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
User | Count |
---|---|
69 | |
65 | |
63 | |
55 | |
28 |
User | Count |
---|---|
112 | |
81 | |
65 | |
48 | |
42 |