Skip to main content

Power BI

New

Detect drilldown (drill-down) level to support changing measure / title

Vote (109) Share
Hymie Ho's profile image

Hymie Ho on 12 Oct 2016 04:09:32

I have a bar chart with a custom hierarchy that drills through different groups of people (sales managers, territory managers, etc.). On the same report I have a measure that calculates AVERAGE (Sales). I want that measure to show the average sales for the current hierarchy (by Sales Managers or by Territory Managers). Here is some pseudo-code with a new DAX command YAXISVALUES that shows how I would use this:

Average Display Value =
VAR
Total=
SWITCH(YAXISVALUES () ,
"SM", SUM('Sales'[Sales ($)]) / DISTINCTCOUNT('Sales'[SM]),
"TM", SUM('Sales'[Sales ($)]) / DISTINCTCOUNT('Sales'[TM])
)
RETURN
IF(ISBLANK(Total),0,Total)

See this topic for other use cases: https://community.powerbi.com/t5/Developer/Dyanmically-changing-the-title-based-on-the-drill-down/td-p/33411

Comments (5)
Hymie Ho's profile image Profile Picture

f36e5b28 b6e9-47f2-824f-b501494646b2 on 05 Jul 2020 23:46:16

RE: Detect drilldown (drill-down) level to support changing measure / title

This would be so useful!

Hymie Ho's profile image Profile Picture

6241fe54 1f22-499c-b170-150b1b0571c0 on 05 Jul 2020 23:43:10

RE: Detect drilldown (drill-down) level to support changing measure / title

This would be really helpful!

Hymie Ho's profile image Profile Picture

df9eac80 f637-4799-8576-17ffbcea3feb on 05 Jul 2020 23:42:39

RE: Detect drilldown (drill-down) level to support changing measure / title

This would be great to show the breadcrumbs when end-users drill down through a chart.

Hymie Ho's profile image Profile Picture

51af57f3 78fe-476d-aebf-cdb52004f81a on 05 Jul 2020 23:38:00

RE: Detect drilldown (drill-down) level to support changing measure / title

Please! I am still waiting for this!

Hymie Ho's profile image Profile Picture

7f60af5c 18c3-42fb-8501-97fc98ad476b on 05 Jul 2020 23:30:26

RE: Detect drilldown (drill-down) level to support changing measure / title

would love this idea, please add this