cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
featleyd Regular Visitor
Regular Visitor

Drill-Down in Power BI webpart for Sharepoint Online

Hello everyone

 

I've slaved away over my dataset to create some flash drill downs, which i think look great.

 

I've published it to my Modern Sharepoint site, and I can't access the drill-down function!

 

What's happened to it, how can I get it back?

 

Any help is appreciated!

1 ACCEPTED SOLUTION

Accepted Solutions
featleyd Regular Visitor
Regular Visitor

Re: Drill-Down in Power BI webpart for Sharepoint Online

Hi @v-shex-msft 

 

I've solved it!

 

I had disabled the 'Visual Header' setting for the visual. As soon as I toggled it to "On", the usual drill-down icons appeared in my Modern Sharepoint site.

 

Thanks for your help with this.

 

Kind Regards

View solution in original post

9 REPLIES 9
Community Support Team
Community Support Team

Re: Drill-Down in Power BI webpart for Sharepoint Online

HI @featleyd,

 

Have you turn on the 'hide visual header in read view' option? If this is a case, it will auto hide tile head and drill feature icons when you in read view mode.

3.png

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
featleyd Regular Visitor
Regular Visitor

Re: Drill-Down in Power BI webpart for Sharepoint Online

Hi Xiaoxin

 

Thanks for your reply, sadly no I hadn't checked that button.

 

I've checked again on my Modern Sharepoint site this morning, and although I can right click the visual to drill down, the type of interaction I'm after is for my user to be able to click the graph and it drills down, much like when I activate the drill down button in Power BI Desktop and click through the graph.

 

I've activated everything I think could be linked to get this result and I can't find anything! Any further suggestions?

 

Community Support Team
Community Support Team

Re: Drill-Down in Power BI webpart for Sharepoint Online

HI @featleyd,

 

I can't reproduce your issue, drill features works on my side. can you please provide more details about this?

8.png

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
featleyd Regular Visitor
Regular Visitor

Re: Drill-Down in Power BI webpart for Sharepoint Online

Hi @v-shex-msft 

 

Thanks for your reply.

 

Apologies if anything in my post was unclear.

 

So I've built a report in Power BI Desktop, with a graph that has a heirachy so my user can drill-down.

 

Here is a picture of it in Power BI Desktop:

 

Forum 1.PNG

Here is a picture of it after i click directly on the bar for January:

 

Forum 2.PNG

As you can see, the data in the heirachy takes affect with the drill down and the next chart in the heirachy is shown.

 

I uploaded this report to the Power BI Online service, and then got the link to embed it into my Modern Sharepoint site, expecting it to have the same behaviour, however here is a picture of the the same graph, but in the Modern Sharepoint site.

 

Forum 3.PNG

And here is a picture of the graph when I click directly on the bar for January:

 

Forum 4.PNG

 

I can right-click the graph in the Modern Sharepoint to drill-down, as shown below:

 

Forum 5.png

However, this is not the behaviour that I want my users to follow (as I feel my audience will be disuaded from accessing the extra data by having an additional right-click involved), I'd like them to just click the graph to drill down, as I can in Power BI Desktop.

 

Is this enough information for you to investigate?

 

Thanks in advance for your time.

Community Support Team
Community Support Team

Re: Drill-Down in Power BI webpart for Sharepoint Online

HI @featleyd ,

 

Nope, current you can't do customize on that tooltip menu.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
Highlighted
featleyd Regular Visitor
Regular Visitor

Re: Drill-Down in Power BI webpart for Sharepoint Online

Hi again

So just to confirm, the ONLY way to drill down in a Power BI report that has been embedded in a Modern SharePoint site is the horribly inefficient right-click method?

Kind Regards

Daniel
Community Support Team
Community Support Team

Re: Drill-Down in Power BI webpart for Sharepoint Online

Hi @featleyd ,

 

As I said, drill features button available when you embed report to sharepoint side.

 
Current power bi not contains option to disable right click on 'quick menu' you can use both 'drill buttons' and 'drill menu' two functions to control which hierarchy level displayed.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
featleyd Regular Visitor
Regular Visitor

Re: Drill-Down in Power BI webpart for Sharepoint Online

Hi @v-shex-msft 

 

Thanks for this.

 

Can you find a reason why the drill up and down icons don't appear on the Modern Sharepoint embedded report?

 

 

featleyd Regular Visitor
Regular Visitor

Re: Drill-Down in Power BI webpart for Sharepoint Online

Hi @v-shex-msft 

 

I've solved it!

 

I had disabled the 'Visual Header' setting for the visual. As soon as I toggled it to "On", the usual drill-down icons appeared in my Modern Sharepoint site.

 

Thanks for your help with this.

 

Kind Regards

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors