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

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

Anonymous — Tue, 21 Nov 2017 06:33:41 GMT

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..

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

v-viig — Tue, 21 Nov 2017 14:32:45 GMT

Are you talking about Drill-down donut chart?

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

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

Anonymous — Wed, 22 Nov 2017 05:34:23 GMT

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

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

Eric_Zhang — Wed, 22 Nov 2017 07:36:06 GMT

@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")

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

Anonymous — Wed, 22 Nov 2017 11:50:36 GMT

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