Forum Discussion
Apply filter for column PowerBI desktop
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?
3 Replies
- Idrissshatila
Super User
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 👍
Thank you. Can you please be more specific? What do you mean by '
ussing the dax measure of everyone of them'
- Idrissshatila
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 👍
