Related products report

[arthastic]

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)

ChequeDetails (ChequeID, ProductID, Qty, Price, Sum)

Pruducts (ProductID, ProductName, Article).

So I want to select period and product that I'm interesting in and see the list of related products.

Have you any idea how to do this report or you've done something same?

[arthastic]

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]

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]

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

[v-qiuyu-msft]

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]

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.