Skip to main content
Microsoft Idea

Power BI

New

Power BI Built in way to group measures at Lower than a value and include a grouped description for them

Vote (3) Share
Debbie Edwards's profile image

Debbie Edwards on 15 Feb 2024 11:07:22

I work on many Projects where the users don't want to show measures that are lower than a certain number. Say 10 as an example.

In this case


Area Total

A 100

B 90

C 9

D 1

E 5


Should become

Area Total

A 100

B 90

Areas below 10 15


At present there are ways around this that involve adding extra tables (Not good when you have a clean star schema). cartesian joining. extremely Complex DAX etc. it feels like something that should be much easier to resolve.


It would be great if Power BI Included something that a user would be able to include easily on the visual. Something like the Not N in the Filters Pane.


this would massively help when we need to include more data protection. Hiding smaller numbers on reports.