Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
markst
Frequent Visitor

Inform Report User of DrillDown Hierarchy Available in a Given Visual

Hi All,

Many of our report visuals provide hierarchical drill-down.  Report users do not know the hierarchy levels until they actually drill-down.  Is there a way to provide information on the drill-down hierarchy for a given out-of-the-box visual that a report user can see without having to actually drill down?  At the moment I am including a text list of the hierarchy levels for a given visual and providing the user with a button that toggles its visibility.  This approach is tedious and adds a lot of time to managing a report design.

thanks in advance 🙂

1 ACCEPTED SOLUTION

Hi @AllisonKennedy, Thank you for the information.  While waiting for responses I learnt about the new "Visual Header Tooltip".  I will use this new feature and Report Tooltips to provide the required info.

regards

Mark

View solution in original post

2 REPLIES 2
AllisonKennedy
Super User
Super User

Not exactly sure what info you're trying to display, but you could build a measure that outlines the available hierarchy levels and use the drilldown button functionality to set the text and tooltips for the button to use that custom measure. That will still be a bit tedious and manual in the creation of it. You can also train users to use the Filter pane to see what data might be available if they drill down, those this isn't certain as it's possible to add more fields to filter than are in the hierarchy.

Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Hi @AllisonKennedy, Thank you for the information.  While waiting for responses I learnt about the new "Visual Header Tooltip".  I will use this new feature and Report Tooltips to provide the required info.

regards

Mark

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.