Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

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

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

drilldowndonut.gif

View solution in original post

4 REPLIES 4
v-viig
Community Champion
Community Champion

Are you talking about Drill-down donut chart?

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Anonymous
Not applicable

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


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

drilldowndonut.gif

Anonymous
Not applicable

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors