Forum Discussion

arthastic's avatar
arthastic
Icon for Advocate I rankAdvocate I
9 years ago

Related 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...
Need Help
arthastic's avatar
arthastic
Icon for Advocate I rankAdvocate I
9 years ago

Hi! 

I decided to made this report by slicers.

1)  Find Cheques with products I'm interesting in by using slicers (Time and ProductName)

2) Mark all selected cheques and have the result in stacked bar chart

But there're thousands/handreds of cheques with a same products in my real base and it's uncomfortably to mark them separately with mouse clicking. "Select All" control select all the cheques in the ChequesTable but not cheques that I select by clicers in first step.

Do anybody knows how to select only neded cheques in the ChequesSlicer?

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

Hi 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

  • arthastic's avatar
    arthastic
    Icon for Advocate I rankAdvocate I
    9 years ago

    Hi 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