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

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