Exclude Function

[Umadhandapani]

Hi,

In the image, if I select particular value and selecting the 'Exclude' button, it should exclude the value. (Similar to filterfunction, where value apart from selecting should display)

Whether it is possible?

[Anonymous]

Hi @Umadhandapani ,

You can row-level security (RLS) with Power BI Desktop to restrict data access for given users.

Or

Using M Query:

Table.RemoveColumns(

    Table.FromRecords({[CustomerID = 1, Name = "Bob", Phone = "123-4567"]}),

    "Phone"

Hope this helped you in answering your question.

Many Thanks!

[v-chenwuz-msft]

Hi @Umadhandapani ,

Unfortunately, power bi does not have this feature right now.

Or you can use filter pane to remove this items by un-selected this item.

You can submit your ideas on power bi ideas.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mh2587]

** I am assuming that Amount is a Measure not column so Dax will be below

Exclude = calculate([Amount],table[Kingdom] <> "protists")

[mh2587]

It will Exclude that particular record from the visual

[Umadhandapani]

But not using right-click and exclude. Using some measures required.