Forum Discussion
arthastic
Advocate I
Advocate IRelated products report
Hi! Need help! I need to do a report which shows me product, that is saled in same cheque whith a product I will select. There are 3 tables in sources: Cheques (ChequeID, ChequeTime) ChequeDe...
v-qiuyu-msft
Community Support
Community SupportHi arthastic,
You can set the ChequeTime and ProductName filter the ChequeID, and ChequeID slicer filter the chart. The values returned in ChequeID slicer are available filtered by both ChequeTime and ProductName, you can check "Select All" option in ChequeID slicer to filter cahrt data. Please check if attached .PBIX file meet your requirement.
Reference:
Visualization interactions in a Power BI report
Best Regards,
Qiuyun Yu
arthasticAdvocate I
Advocate IHi v-qiuyu-msft ,
It doesn't work correct. I see it even on printscreen attached by you.
1) Sum of Car sales in cheque 1 and 2 isn't equal 246;
2) "Select All" option in ChequeID slicer doesn't filter chart data as expected