Need parent name in the Drill-down donuts report at the child level

[Anonymous]

I need the parent name at the child level when I drill-down to the child level in drill-down donuts report, so that I can represent it somwhere in my report.

Any suggestion..

[v-viig]

Are you talking about Drill-down donut chart?

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

[Anonymous]

Yes @v-viig. Drill-down donut chart by Zoomcharts.

[Eric_Zhang · Accepted solution]

---

@Anonymous wrote:

Yes @v-viig. Drill-down donut chart by Zoomcharts.

---

@Anonymous

You can just create some tricky measures to achive your goal. See my demo on the attached sample.

first Level Parent = IF(ISFILTERED(hr[Department]),MAX(hr[Department]),"To drill down")

second Level Parent = IF(ISFILTERED(hr[Department])&&ISFILTERED(hr[Title])&&HASONEVALUE(hr[Title]),MAX(hr[Title]),"To drill down")

[Anonymous]

Thanks a lot @Eric_Zhang. It worked for me..