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
Refresh SQL Analytics endpoint activity in Fabric pipelines not working when deploying
Hi all, I noticed that the Refresh SQL Analytics endpoint activity is not saving the workspace id so when trying to deploy the pipeline which is using this activity, the deployment failed since the ...adrianrivas072 hours agoNew MemberNew2Views0likes0CommentsAllow Programmatic Names for Renamed Fields in a Visual
I would like it if renamed fields in visuals could be set programmatically rather than having a fixed name. I work with reports in multiple languages and whilst you can add support for another langua...CoulterJames23 hours agoAdvocate IINew24Views7likes0Commentsfreeze column in a table chart
It'd be great to be able to freeze a left hand column in a table so users can scroll and keep track of what row they're looking atv-joklin3 hours agoNew MemberNeeds Votes9KViews1666likes101CommentsDeployment pipeline: Deployment rules for Direct Lake on OneLake semantic models
Currently, it is not possible to use deployment rules with Direct Lake on OneLake semantic models. The option is greyed out. Please enable this, so we can automatically change the data so...frithjof_v4 hours agoCommunity ChampionNew6.5KViews153likes20Comments