Forum Discussion
Helper VALLSELECTED on a slicer
Hi,
Is there a way to use AllSelected on a slicer ?
I have few slicers on the report and wanted to use the different slicer selections for different tables.
Slicer 1 will filter table 1
Slicer 2 will filter table 2 and so on.
Using edit intractions I have achieved the filter context but I need to add a column to the table but this needs to look at only slicer 2.
Is this possible?
thanks.
Hi, PBIfanatic
Here is a demo.
If help ,please try steps as below.
1.duplicate table and click "close&apply"
2.Create calculate table as the slicer of table 2
Table = DISTINCT('financials'[Country])3. create measure as below to replace the column your mentioned.
MEASURE COGS2 = CALCULATE(SUM(financials[COGS]),FILTER(CALCULATETABLE(ALLSELECTED('financials'),ALL(financials[Country])),'financials'[Country] in DISTINCT('Table'[Country])))4.Using edit intractions to achieved the filter context
it will show as below
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
8 Replies
- kentyler
Solution Sage
Do table 1 and table 2 have relationship(s)
If so, when the table 1 slicer slices table 1 it might also affect the records displayed from table 2, and vice versa.
If there are no relationships between the 2 tables, then you can create your slicers directly from columns in the tables, and each slicer will slice only the table it is drawn from.
PBIfanaticHi kentyler ,
Thanks for your reply.
I meant table visualization, there is just 1 table in the data model.
I wanted to do comparitive analysis, so I need to replicate the slicers and tables and then make different selections on the slicers.
thanks.
- kentyler
If you go to Power Query you can make a "reference" copy of the table, which should not be affected by slicers you put on the first table, and you should be able to "slice" the reference table independently
