Advanced visualization

[mdandhare]

Hi,

I am trying to get Drill Through data by Right click on visuals, but some external visualization does not support Drill Through option.

It is showing filtered data but upto basic level of 'Sunburst graph'. 

When I drilled through '1' data comes correct. But when I drilled through 'Male' which is second hierarchy, data comes incorrect.

I am attaching screenshot of visual and drilled data sample. Could anyone can help me with the Drill Through option?ChartI selected Drill Through on MaleBut I got all the data without filtration

[Anonymous]

Hi  @mdandhare ,

According to the research, this visual drill object is drilled according to the field placed on the Category. If you put [Risk_level(5-max)] on it, the drill will only affect the [Risk_level(5-max)] to drill down.

I put [Pat_Gender] in Category, and the visual will press [Pat_Gender] to drill through.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mdandhare · Accepted solution]

Hi @Anonymous ,

You have changed the hierarchy of fields. This is not the solution. 

We can conclude that Sunburst chart only supports base level Drilled Through(only 1 level). If we use drill through on hierarchical basis it fails.

[mdandhare]

@amitchandak 

I can't able to share .pbix on this platform. Don't know why.I have shared the link of google drive and you can find the .pbix file here. Just download it and open in Desktop version. Thanks.

https://drive.google.com/file/d/17Ax8-oT49iKdajYetZ1UUeK5dw6Lc_I5/view?usp=sharing

[mdandhare]

Ya sure! Please find attached link. Just try to drill through Sunburst graph by 2nd and 3rd hirarchy. Thanks.

https://drive.google.com/file/d/17Ax8-oT49iKdajYetZ1UUeK5dw6Lc_I5/view?usp=sharing

[amitchandak]

@mdandhare , Check that you have dragged the required column into add drill through here

or make sure keep all filtered is checked

[mdandhare]

Hi,

I have added the required fields in the 'Add Drill Through Field' eventhough it not filtering to 2nd or 3rd Hirarchy. Is there are something I am missing out?

[amitchandak]

@mdandhare ,
Can you share a sample pbix after removing sensitive data.