Forum Discussion
Resolver IISlicer Input in a field value
Hi Friends
Please help on this
I have 4 slicers in a page and based on the inputs from slicer table visual works. I want to show a field from this page table to another report and I cant use this slicers in new report
So I create a calc column like
Column = Calc(
sum(fieldvalue),
filter(tablename, slicer1value="v1" && slicer1value="v2"),
filter(tablename, slicer2value="v1" && slicer2value="v2"),
filter(tablename, slicer3value="v1" && slicer3value="v2"),
filter(tablename, slicer4value="v1" && slicer4value="v2")
)
But its not working Please help
3 Replies
- MFelix
Super User
Hi RENJITH_R_S ,
Select the 4 slicers and copy and paste them on the second page when you do this a sync option will pop up say yes and the slicers will be sinc so a selection on one page will be repetead on the other page.
If you don't see the sync option follow the link below with the full explanation.
Them you just need to hide the slicers on the second page and turn off interactions on that page with other visualizations.
Other option is to use the drill-trough option
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough
RENJITH_R_SMFelix ,
Thanks for replying, By mistake I type 1 page to another. My requirement is from a report to another report
- MFelix
When you refer report is two different PBIX files?
For this you need to use the drilltrough option to different reports check the link below, this is only usable in service you cannot replicat this on the desktop version altough the setup is done there.
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-cross-report-drill-through
Be sure that the two reports have the same fields so the cross filter can work.
