Skip to main content
Microsoft Idea

Power BI

Needs Votes

conditional edit Interactions

Vote (1) Share
Hari Kumar's profile image

Hari Kumar on 19 May 2021 06:17:00

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