Apply filter for column PowerBI desktop

[Omelei]

Hi guys, 

Hope you can help. See my table attached.

In PBI I have added the SUM of revenue of all opportunities stacked in a chart per category (existing business vs. new business vs. lost business)

Now I'd to apply a filter 'business type' with the following three values:

1. Existing business

2. New business

3. Lost business

Any idea?

[omelei86]

Thank you. Can you please be more specific? What do you mean by '

ussing the dax measure of everyone of them'

[Idrissshatila]

@omelei86,

So you create a dax measure for Existing business that has the filters you want and make the same for the other two.

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍

Follow me on Linkedin

[Idrissshatila]

Hello @Omelei ,

If you want the filter to only affect the three mentioned points then you may filter them ussing the dax measure of everyone of them.

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍

Follow me on Linkedin