hymie_ho
10 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
Custom visuals: allow same-tab navigation & reduce confirm-navigation friction for trusted links
Description: Custom visuals (e.g. Deneb) that trigger navigation via href currently have two limitations that create friction for legitimate, author-controlled use cases: Links always open in a ne...AlexSenEON1 hour agoNew MemberNew16Views1like1CommentAdd a Global Option to Disable Tooltips in Power BI Settings
Description Currently, Power BI provides an option to disable tooltips at the individual visual level. However, there is no global setting to disable tooltips across an entire report or throughout ...Murtaza_Ghafoor13 hours agoSuper UserNew6Views1like0CommentsIncrease 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...sharadmahajan2 days agoRegular VisitorNew341Views21likes3Comments