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
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

Hi arthastic,

 

In your scenario, you can build a relationship among those three tables. Then create a clustered column chart, place ChequeID in Axis property, ProductName in Legend and Sum in Value. Drag two slicer visuals into the report, one has ChequeTime, the other has ProductName. Then you can check prefer ChequeTime and ProductName to filter chart data. See:

 

 

You can check my attached .PBIX file. If the report doesn't meet your requirement, please share desired results with us.

 

Best Regards,
Qiuyun Yu

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

    Thanks v-qiuyu-msft! But I need a bit different result.

    For example:

    when I select Bike (which was saled by cheques 1 and 2) In the result list I want to see next:

    Bus 288

    Cars 138

    So there are the products and sums, that was saled with Bikes in same cheques.