hymie_ho
9 years agoNew Member
Status:
Needs Votes
Detect drilldown (drill-down) level to support changing measure / title
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
8 Comments
- sandersmits289New Memberwould love this idea, please add this
- gabrielacampaniNew MemberPlease! I am still waiting for this!
- donscottNew MemberThis would be great to show the breadcrumbs when end-users drill down through a chart.
- irenereche92New MemberThis would be really helpful!
- Helena_MealinNew MemberThis would be so useful!
- fbcideas_migusrNew MemberWithout this labelling on a matrix I can not add levels to the columns because they do not know what they are . The rows provide a row header but this is missing from the column
- kostas-a_laurinNew Member
Still waiting for this.
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Org apps - Cannot be arranged in folders and do not stay hidden
Currently, Organizational Apps (Org Apps) are displayed in the standard Apps section of the Get Apps experience, alongside regular workspace apps. For organizations managing large-scale Power BI depl...akonda6 hours agoNew MemberNew5Views0likes0CommentsIncrease or Make Configurable the Power BI Browser Tab Limit (Currently 20 Items)
Power BI users frequently work across multiple reports, dashboards, semantic models, notebooks, and Fabric artifacts simultaneously. The current browser limitation of 20 open Power BI/Fabric items re...sharadmahajan8 hours agoRegular VisitorNew339Views21likes3CommentsAdd "NO SELECTION" default selected option to slicers
Scenario Currently, slicers have two states: No value selected (bogs report down) BI dev preselects one or more data values (problematic when reports are consumed by other clients/users) Option...arpost10 hours agoPost ProdigyNew8Views0likes0Comments