Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

conditional edit Interactions

Please consider the following scenario The following are the Matrix Row Values Revenue Cost of sales Operating Expenses Net Income The following is the Matrix column Name Year Base on the above matrix fields, I created a waterfall chart to show the Net Income. This chart is interactive but i don't want to apply any filter to this chart while selecting a row from the matrix. But filtering should be activated whenever i select the column header(Year) such as 2019, 2017 etc... .At present, selecting the column header will show the waterfall chart as intended but if i select one of the row values, chart will filter accordingly and waterfall chart will show the value of selected row(s) and waterfall chart will show incorrect value as net income. If possible, you can provide an option for edit interaction filter 1. Filter All (available in power bi) 2. Only Rows(Required) 3 Only Columns(Required) Thanks and regards
Status: Needs Votes
Comments
fbcideas_migusr
New Member
Status changed to: Needs Votes