Forum Discussion

SelflearningBi's avatar
SelflearningBi
Icon for Helper III rankHelper III
4 years ago

Is it possible to create a pie chart between two tables

I am new to power bi still on learning path. I would like to create a pie chart between two of my table.  
Table 1:  Contains all of my Products  
Table 2: Only Contains Impacted Products and look like following table: with reason, ,weeks of delay being impacted and so on. 

 

I would like to create pie of pie chart look like this:  ( Or smiliar) 

 

On time % is from Table 1 (total quantity)
Other% is from table2 (impact quantity)

and those other covid impact, t2 material is from table 2 the reason( impact quanitty by reason) 

I try this,, but dont think it right. 

 




 

 

Need Help
Show and Tell

10 Replies

  • Dhacd's avatar
    Dhacd
    Icon for Resolver III rankResolver III
    4 years ago

    Good Day SelflearningBi ,
    This can be achieved by drillthrough page in powerbi.
    I can attach screenshots on how to do this if requires. 

    Thanks and regards,

    Atma.

      • Dhacd's avatar
        Dhacd
        Icon for Resolver III rankResolver III
        4 years ago

        You need to create a drill-through page. which means the add another page and then adding the reasons visual to that page. And in the drill through section add the measure you have used in the first visual and filter it for other reasons.

         you can right-click to the first visual(on other reason area of the pie chart) and click on drill through .you will be redirected to this page

    • SelflearningBi's avatar
      SelflearningBi
      Icon for Helper III rankHelper III
      4 years ago

      Hariharan_R 
      Thank for helping, but what if i dont have 1 to 1 relationship ? 
      I have also posted similar dataset that im using. 
      I would also later to create slicers by using Name, S/O and supplier name, BU, and calcualte the differenct between this table：% of quantity being impact 

      is it possible to do cross table calcualtion like this: Order Quantity - Impact Quantity  and the impacted %? 

      Order Table 1

      NameBUSupplier NameFactory NameModel NumberS/OOrder Quantity
      JackAPPAKK11IDE10
      FIFIFWAKK11IDE5
      AmyAPPAC12ICH2
      AmyAPPBB13IPP10
      AmyFWBB14IDE10
      AmyAPPCKK66IDE10
      AmyAPPCKK89IDE10
      AmyHWDD12ICC10
      AmyAPPCKK66IDE10
      JackFWCKK89IDE10
      JackAPPDD12ICC10
      JackAPPGGG10IDE10
      JackFWGGG1IDE10
      FIFIAPPGGG1ICC10
      FIFIAPPGKK15IDE10
      FIFIFWFO17IDE10


      Delay Table 2

      NameBUSupplier Name
             		Factory Name
             		Model Number

      		S/OImpact QuantitySolutionReasonWeek of delayImpacted Qty
      JackAPPAKK11IDE10GOODCOVID IMPACT1 WEEK3
      FIFIFWAKK11IDE5GOODMATERIAL2 WEEK3
      AmyAPPAC12ICH2GOODCOVID IMPACT3 WEEK1
      AmyAPPBB13IPP10GOODMATERIAL2 WEEK3
      AmyFWBB14IDE10GOODMATERIAL1 WEEK3
      AmyAPPCKK66IDE10GOODCOVID IMPACT1 WEEK4
      AmyAPPCKK89IDE10BADMATERIAL2 WEEK4
      AmyHWDD12ICC10BADCOVID IMPACT4

       

      • Hariharan_R's avatar
        Hariharan_R
        Icon for Solution Sage rankSolution Sage
        4 years ago

        Hi,

        You can concatenate the first 6 columns to make a distinct values on both the tables and can build a relationship between the tables. Check the cardinatlity on the relationship. You can use RELATED or RELATEDTABLE DAX functions get the values from one table to another as a calculated columns. You also can acheive through DAX using the relationship between the tables.

         

        Thanks

        Hari