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

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

 

 

 

      • vjnvinod's avatar
        vjnvinod
        Impactful Individual
        8 years ago

        Anonymous

         

        Hi Lydia,

         

        thanks for taking your time and responding back, note that the view which you have created, i already have that view in my dashboard, unfortunately this doesn't helps, as the user has to select manually the 2 dropdowns to summarise the inbound and outbound revenue for a single region

        what i am looking is a  combined  (joint ) view of those 2 matrix (which is in the PBIX file you have shared)  in Power BI using just only one dropdown (Delivery and HQ region should act as one dropdown), see the below snapshot of expected result. is it possible to create a view like this?

        Expected view in Power BI