- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
Exclude values that are selected
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-03-2018 02:20 PM
Hey there,
I really need a bit help. I have a scatterplot which has Cost and Revenue.
Using slicer I need to filter out all GM values.
Ex. if slicer is selected from 3 to 5. Then all GM values from 3 to 5 should not be seen in the graph.
Here is the file: https://mega.nz/#!DrJnXazJ!st7Rc_xYXhKVli6K2Sw4iUJD-9gaECOBoG8JG_zp9MI
Thanks a lot for the help
Regards,
Ignas
Solved! Go to Solution.
Accepted Solutions
Re: Exclude values that are selected
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-04-2018 02:20 AM
Hi @ignas
Create a new table which is not connect to your table
Table = SUMMARIZE('fact','fact'[GM])
then create measures
min = MIN('Table'[GM]) max = MAX('Table'[GM]) flag = IF(MAX('fact'[GM])<=[max]&&MAX('fact'[GM])>=[min],1,0)
Best Reagrds
Maggie
Re: Exclude values that are selected
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-05-2018 01:33 AM
Hi @ignas
I don't see [year] column in your pbix.
If "SUMMARIZE only those lines that have column Year FY" refers to the new created table.
You could try this formula
Table=SUMMARIZE(FILTER('fact',[year]="FY"),'fact'[GM])
Best Regards
Maggie
All Replies
Re: Exclude values that are selected
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-04-2018 02:20 AM
Hi @ignas
Create a new table which is not connect to your table
Table = SUMMARIZE('fact','fact'[GM])
then create measures
min = MIN('Table'[GM]) max = MAX('Table'[GM]) flag = IF(MAX('fact'[GM])<=[max]&&MAX('fact'[GM])>=[min],1,0)
Best Reagrds
Maggie
Re: Exclude values that are selected
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-04-2018 11:10 AM
Hello @v-juanli-msft
It is an amazing solution.
I just have one more thing that I cannot make it working.
I need to SUMMARIZE only those lines that have column Year FY.
I cannot find any solution how I could include filter.
Link to the file: https://mega.nz/#!y6Z0TA5D!pbwZSsFrIdjiGvVXQ0cBxjHQ_KRto9GO4p7E3sTNrpU
Thanks a lot for helping
Regards,
Ignas
Re: Exclude values that are selected
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-05-2018 01:33 AM
Hi @ignas
I don't see [year] column in your pbix.
If "SUMMARIZE only those lines that have column Year FY" refers to the new created table.
You could try this formula
Table=SUMMARIZE(FILTER('fact',[year]="FY"),'fact'[GM])
Best Regards
Maggie
Re: Exclude values that are selected
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-05-2018 02:59 AM
Hey Maggie
You are amazing. It really works. I tried with Filter but I did something wrong.
Regards,
Ignas