Forum Discussion
Second level data value when in drill down
Hello ,
We have a report where we have bar graphs overlaid on one another with buttons acting as bookmarks to display each graph visual.
(We couldn't use dynamic x-axis as all other visuals didn't interact with it and it would have been a complicated DAX)
A few of these graphs have second levels which can be drilled down to. Now the issue is if a user drills-down in one visual and then clicks the button and goes to other bar graph, the filter remains and other visuals also get filtered. We want to have a text box/card/button anything which can convey where are we drilled down ( some users use multiple drill down)
Adding a dummy model below
Suppose, the two graphs are on overlaid and visibilty is controlled with buttons and bookmarks.
We can drill down into individual names.
And if we are drilled down into one bar, then we want to display that information as a title/text or something.
I understand that if we check the filter pane, we can se what is filtered but it's not possible for our users to do that.
If you have any workaround/solution to this problem, please let me know.
Thanks,
Sneha
Edit 1: I was able to solve this issue using HASONEFILTER(Table_name[column_name]),TRUE, FALSE) feature and selectively displaying text like that.
- Anonymous4 years ago
Thank you for your response, looks like an interesting read. I was able to solve this issue using HASONEFILTER(Table_name[column_name]),TRUE, FALSE) feature and selectively displaying text like that.
2 Replies
- PC2790Community Champion
Hey Anonymous ,
See related threads that might be helpful
Solved: Chart Titles that adjust to the drill down layer - Microsoft Power BI Community
Solved: Display Each drill down level on report (Like - Br... - Microsoft Power BI Community
Solved: dynamic title based on drill through selection - Microsoft Power BI Community
- AnonymousNot applicable
Thank you for your response, looks like an interesting read. I was able to solve this issue using HASONEFILTER(Table_name[column_name]),TRUE, FALSE) feature and selectively displaying text like that.