cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dhpowerbi
Frequent Visitor

Dynamic stacked column chart aggregate values vs holdings values

Hi all, first time poster here so apologies if there are any answers to this question out there (havent found any yet). I am using a stacked column chart to show a breakdown of total Fair Market Value of some funds. This FMV is broken down into Cost Basis and Unrealized P/L with the total being equal to the FMV of the portfolio. When clicking on a holding I would like the y axis to rescale to the show the breakdown of the individual holding, rather than the whole portfolio. Ive attached some images below, any help would be much appreciated.

ie. in the second picture I would want to show just $5.9M in Cost Basis and $12.3M in P/L with a total of $18.2M, rather than having it still show as a proportion of the total portfolio.

Thanks All!

 

 

 

1 ACCEPTED SOLUTION
dm-p
Super User I
Super User I

Hi @dhpowerbi,

If I understand correctly, I think that editing the interactions from the source visual so that it cross-filters your column chart rather than cross-highlighting should achieve this.

Good luck!

Daniel





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


My course: Introduction to Developing Power BI Visuals


On how to ask a technical question, if you really want an answer (courtesy of SQLBI)




View solution in original post

1 REPLY 1
dm-p
Super User I
Super User I

Hi @dhpowerbi,

If I understand correctly, I think that editing the interactions from the source visual so that it cross-filters your column chart rather than cross-highlighting should achieve this.

Good luck!

Daniel





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


My course: Introduction to Developing Power BI Visuals


On how to ask a technical question, if you really want an answer (courtesy of SQLBI)




View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.