Forum Discussion

MikeHalsey's avatar
MikeHalsey
New Member
9 years ago
Solved

Drilldown not working on published report

I have a visual that I have created on Power BI Desktop.  All works well and the report allows me to drill-down though my data without any issues whatsoever.  I have published as a Bar Chart with aro...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi MikeHalsey,

     

    Glad to hear you have found the solution. As the issue is solved, would you please mark the reply which you are satisfied as an answer so that we can close the thread?

     

    Best Regards,
    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

Hi MikeHalsey,

 

According to your description, the drill down report works fine in Power BI Desktop, after publish to the My Workspace, the drill down button is greyed out, right?

 

In your scenario, please verify the chart also has hierarchy in service. If there is no hierarchy, the drill down button is greyed out. See:

 

Also you can publish the attached .PBIX to your My Workspace to see if drill down is available.

 

Reference:

Drill down in a visualization in Power BI.

 

Best Regards,

Qiuyun Yu

MikeHalsey's avatar
MikeHalsey
New Member
9 years ago

Hi there

 

Your drill down example works perfectly in PBI Desktop and PBI Web... which is a good start as it means I'm not doing anything wrong on the publishing side of things.

 

I can't see the difference though between your example and mine.  I'm guessing there is another setting in PBI Desktop that I need to change for the report before I publish it to enable the 'Click to turn on Drill Down' arrows?

 

Your example has a 2 layer heirachy, mine has 7 layers.

In PBI Desktop both yours and mine allow drill down after I click the little arrow in the top right corner of the report that says 'Enable Drill Down'

After publishing to PBI Web, yours still has the 'Enable Drill Down' arrow but mine doesn't so I'm a bit puzzled.

 

Hope you can help

 

Thanks again