Need Help to Drill down Trending data as per Slicer Selection.

[SC30GSWNBA]

Hello All,

I have got a trending data that I am able to Drill Up and Go one level down the hierarchy using the Drill down option on the chart, but I want to give the user to drill up or go one level down in hierarchy by slicer selection. Is it possible to build dynamic view based on slicer selection. So when the user selects 'Yearly' in Slicer, it should give the following view-

On selecting 'Monthly' in slicer, it should give the following view-

On selecting 'Daily' in slicer, it should give the following view-

In short the view should be based on slicer rather than Drilling up. I am attaching the pbix file for reference. Please help me if that's possible. I have got to prepare a presentation to the senior management on Monday and I need to get this thing sorted.

[Anonymous · Accepted solution]

Hi @SC30GSWNBA ,

I haven't found a way to use Slicer as an alternative to a drilling operation at this time.

Here's an article on how to use DAX metrics for conditional visual object display that might be helpful:

Dynamic Display in Power BI: Show/Hide Visuals with Slicer Selection (neil-bagchi.com)

My alternative is to save the data in different hierarchies as different Bookmarks,triggered by a button.

Here is the example data I created:

Date	Profit
6/1/2024	200
6/3/2024	250
6/5/2024	300
6/7/2024	350
6/9/2024	400
7/2/2024	190
7/4/2024	280
7/6/2024	360
7/8/2024	470
7/10/2024	520

Saving data of different hierarchies as different Bookmarks after enabling Bookmark in View tab.

Add three buttons:

Enter the name of the button in Text inside Style.

Open Action and assign Bookmark with the corresponding name.

Now, Ctrl + Click each button to view the data for the corresponding hierarchy.

If you want to attach pbix files, consider uploading pbix files to Dropbox, OneDrive, Google drive.

Remember not to log in to your account when uploading pbix files in Power BI Desktop, remember to erase sensitive information.

If you have any other questions please feel free to contact me.

The pbix file is attached.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[SC30GSWNBA]

Thanks @Anonymous , your solution worked like a charm. Also thanks for providing useful tips on how to upload pbix files to Dropbox, OneDrive

[SC30GSWNBA]

I am not able to attach my pbix file here. How do I sent the file