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)

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?

Need Help

5 Replies

  • 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.

  • 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