Forum Discussion
How to modify drill down breakdown
If I click on any of the Discipline then Equip/Reason bars should total up to the exact same figure as of total values in Discipline bars. For example, if I select a bar from Discipline, the reasons bars should sum up as 8.46%.
Any help in forming a column/measure to evalute the problem.
4 Replies
Hi Anonymous,
Do you mean to keep the previous level content and data to show on the detail level? If that is the case, these cannot be achieved by default chart aggregated feature.
You need to write a measure formula to check the current level and write different expressions with all functions to lookup corresponding parent-level values to replace the current display results.Clever Hierarchy Handling in DAX - SQLBI
Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT - SQLBI
Regards,
Xiaoxin Sheng
Hello,
Thanks for support. What I wish is when I click on any of the bars on left visual, right visual should reflect the values in such a manner that it aggregates to same total value of the clicked bar in left visual.
Clever Hierarchy Handling in DAX - SQLBI Will be working for solution from this method.
Cheers.Hi Anonymous,
Did you mean to keep these right part visual total values from the left side interaction to show the total data value as the selected value instead of 100%? If that is the case, these should be the default features of the percent chart which you can't customize.
If you only mean to show the same value on specific data labels between two visuals, you can refer to the shared blog link to know how to use the if statement to check current row contents levels. Then you can write a formula to replace the display values.
Regards,
Xiaoxin Sheng