Description
Currently in Power BI, when a visual contains multiple columns or measures, filtering values within that visual often requires writing complex DAX expressions or creating additional measures and calculation logic.
I would like to suggest a feature where users can filter values directly within a visual column, similar to the filter/drop-down functionality available in Excel tables, without relying on DAX.
Proposed Feature
Once a visual is prepared with multiple columns:
Each column should have an Excel-like filter option
Users should be able to:
Include / exclude specific values
Apply simple conditions (equals, greater than, less than, blank, non-blank)
Filter at the visual level only, without affecting other visuals
Example Scenario
A table visual contains:
Area
Town
village
Activation Count
Qualification Status
Instead of writing DAX to:
Remove blanks
Exclude zero values
Show only qualified Towns
The user can simply apply filters directly on the relevant column inside the visual—just like Excel.
Business Impact
🚀 Reduces dependency on complex DAX
🧠 Improves flexibility for business users
⏱ Saves development and maintenance time
📊 Makes Power BI behave more intuitively for Excel users
🔧 Enables faster ad-hoc analysis without model changes
Current Limitation / Workaround
Requires additional DAX measures
Calculation groups or field parameters add complexity
Not user-friendly for non-technical report consumers
Expected Outcome
Power BI visuals become more interactive and flexible, enabling self-service filtering while keeping the data model clean and simple.
