Forum Discussion

vjnvinod's avatar
vjnvinod
Impactful Individual
8 years ago
Solved

Interaction between dropdown in Power BI

Hi, how to setup an interaction between dropdowns For instance I have 2 dropdowns(which is created out of 2 different field columns). If I select a region from the first dropdown list let say Northea...
  • Anonymous's avatar
    Anonymous
    8 years ago

    vjnvinod,

    You can use DAX instead to create the new tables.  I haven't found any method to put all the data in a single Matrix visual and filter it using a single slicer.

    https://1drv.ms/u/s!AhsotbnGu1Nok0_5dfG96lEqpQr_

    Regards,
    Lydia

vjnvinod's avatar
vjnvinod
Impactful Individual
8 years ago

dropdown interaction issuedropdown interaction issue

Thanks Greg, Appreciate your time on this, i have attached the screenshot, Actual problem is that if you see in the first screenshot Dropdown when i select the HQ region as Northeast, my Delivery region won't automatically change it to Northeast or Vice versa that means i have to manually check the Northeast in the Delivery region

 

Look at the Output required screenshot, what i want to achieve?

i want to achieve if i select any dropdown from HQ region (be in Northeast, southwest any other region) or Delivery region(be in Northeast, southwest any other region), it should automatically change and reflect the same in both.

 

let me know if there is way i can fix this

Anonymous's avatar
Anonymous
Not applicable
8 years ago

vjnvinod,

Do the above two columns come from different tables? If so, have you set proper relationship between the two tables? 

Regards,
Lydia

  • vjnvinod's avatar
    vjnvinod
    Impactful Individual
    8 years ago

    Hi Lydia,

     

    No they come from one table,  eventhough list of regions are same, but in terms of revenue, HQ region may be not equal to Delivery Region, see the below sample for more understanding. & also look at the other table which i want to achieve through one dropdown or slicer

     

    HQRegionDeliveryRegionHomeOutboundInboundTER_FYTD_USD
    CanadaUKIOutbound to EMEIAInbound from Americas13161834
    WestWestHomeHome10046771
    CanadaCanadaHomeHome8415244
    NortheastNortheastHomeHome7681898
    JapanJapanHomeHome7304815
    WestWestHomeHome6827022
    WestWestHomeHome6356509
    WestWestHomeHome6215388
    NortheastNortheastHomeHome5999410
    WestWestHomeHome5836580
    OceaniaAPAC SL CoEOther Asia-Pacific outboundInbound from other Asia-Pacific5572889
    WestWestHomeHome5396988
    WestWestHomeHome5396988
    WestWestHomeHome5388453
    SoutheastSoutheastHomeHome5329472
    SoutheastSoutheastHomeHome5084942
    NortheastNortheastHomeHome5029374
    JapanJapanHomeHome5028924
    WestWestHomeHome5006425
    WestWestHomeHome4978620
    WestWestHomeHome4964660
    WestWestHomeHome4939293
    WestWestHomeHome4900484
    SouthwestNortheastOther Americas outboundInbound from other Americas4875573

     

     

     

    Dropdownfor Region 
    CategoryTER_FYTD_USD
    Home$                 453,625,289
    Inbound from Asia-Pacific$                         673,523
    Inbound from EMEIA$                   33,797,206
    Inbound from Japan$                   18,690,156
    Inbound from other Americas$                     6,976,907
    Inbound from SAcct-Elim$                     -4,557,168
    Grand Total$                 509,205,914
    Home$                 453,625,289
    Other Americas outbound$                   51,136,073
    Outbound to Asia-Pacific$                   31,934,109
    Outbound to EMEIA$                 117,022,067
    Outbound to Japan$                     3,753,733
    Grand Total$                 657,471,271
    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      vjnvinod,

      Could you please describe the logic that you use to calculate the expected result? I note that in your original table, there are no "Inbound from SAcct-Elim" , "Outbound to Japan" values.

      In addition, regarding to your original questions, please check "Edit interactions" between your slicers following the video below.
      https://1drv.ms/v/s!AhsotbnGu1Nok0TMnfg5FI_ymUlW

      Regards,
      Lydia

      • vjnvinod's avatar
        vjnvinod
        Impactful Individual
        8 years ago

        Hi Lydia,

         

        firstly, thanks for reverting, i looked at your videos, unfortunately it doesn't helps, as it doesn't capture the logic i am using to build the dashboard in power BI & the data which you see in the table was just a sample, please ingore those elims.

         

        Please refer the Logic i have captured in the excel sheet1 (its a 2 different pivot) & expected result is from the combination of those two. this is only for a region, so you can refer

         

        https://www.dropbox.com/s/69om7xsw0bujip4/Global%20TMT%20Engagement%20Data%20Extract%20FY17%20P12%20v1.xlsb?dl=0

         

        I want to create the last view in sheet1 through Power BI, wherein if i filter for Northeast or any other region of that matter, the below expected result should appear & numbers gets changed as per the selection.

         

        NORTHEAST  
        CategoryTER_FYTD_USD
        Home$                   453,625,289
        Inbound from Asia-Pacific$                           673,523
        Inbound from EMEIA$                     33,797,206
        Inbound from Japan$                     18,690,156
        Inbound from other Americas$                       6,976,907
        Inbound from SAcct-Elim$                     -4,557,168
        Grand Total$                   509,205,914
        Home$                   453,625,289
        Other Americas outbound$                     51,136,073
        Outbound to Asia-Pacific$                     31,934,109
        Outbound to EMEIA$                   117,022,067
        Outbound to Japan$                       3,753,733
        Grand Total$                   657,471,271