cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dhpowerbi
Regular 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 Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

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.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors