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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
WishAskedSooner
Resolver II
Resolver II

Using a Tiled Slicer to Drilldown on Date

I have been getting some negative feedback about the drilldown icons on a matrix. For example, the first impression to drill down is to click the single down arrow, not the double down arrow or heirachy icon. And who can blame a C-suite user who is constantly stressed and has no bandwidth to figure out the often byzantine design of Power BI visuals? And, I certainly don't want to have to spend time explaining to them how to drilldown. It should be obvious out of the box.

 

For my matrix, the drilldown is basic: Annual, Quarterly, and Monthly.

 

Therefore, I would like to create a tiled slicer that has Annual, Quarterly, and Monthly tiles that the user can click to drill down/up, even skipping heirarchies by going straight from Annual to Monthly and vice versa if they want.

 

Is this possible? Thanks in advance.

1 ACCEPTED SOLUTION
Pragati11
Super User
Super User

Hi @WishAskedSooner ,

 

I wrote a blog sometime back for similar capability. Let me know if this helps.

https://community.fabric.microsoft.com/t5/Community-Blog/Drill-up-Drill-down-Capability-Using-Bookma...

 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

View solution in original post

2 REPLIES 2
WishAskedSooner
Resolver II
Resolver II

@Pragati11 That is exactly what I was looking for and have already implemented it in my dashboard. Thank you so much. This is far more intuitive for the user than the stupid drill icons. Kudos!

Pragati11
Super User
Super User

Hi @WishAskedSooner ,

 

I wrote a blog sometime back for similar capability. Let me know if this helps.

https://community.fabric.microsoft.com/t5/Community-Blog/Drill-up-Drill-down-Capability-Using-Bookma...

 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.