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,

 

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

  • vjnvinod's avatar
    vjnvinod
    Impactful Individual
    8 years ago

    Anonymous

     

    had a chance to check, this helps but i see the matrix display is still 2.

    is there a way we can have a single view covering those 2 matrix/table?

     

    thanks for your help as always.

     

    Regards, vinod

  • vjnvinod's avatar
    vjnvinod
    Impactful Individual
    8 years ago

    Anonymous

    Also i see that you have created 3 tables, out of which 2 tables are created (duplicated) to set the relation between HQ and Delivery.

    The sample i have shared with you doesn't have many coloumns, note that the actual data set has 100+ coloumns, that means if we duplicate and set a relationship, i was wondering whether it will have performance issue or not.

     

    Regards, vinod

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    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

    AnonymousGreg_Deckler

     

    thanks Lydia, appreciate your feedback.!

    is that something we can submit as an idea to implement in Power BI?

     

    at the moment i can use the option you have shared, but i still see challenges regarding the position of the matrix. if you see with the selection of the region, this matrix position keeps moving its position and don't fit appropriately and makes it looks weird. i have applied the lock option in the power BI but still it does really helps.

     

    may be if you have solution for this, do let me know

     

     

  • vjnvinod's avatar
    vjnvinod
    Impactful Individual
    8 years ago

    Anonymous

     

    Hi Lydia,

     

    Can you please help checking when i select a region, my outbound details (lets say filter of Northeast region) are not interacting with my Pie chart and the table.

    please find below the scrubbed PBIX file

     

    https://www.dropbox.com/s/20u6v9kpwr6xehc/Testcheck.pbix?dl=0

     

    thanks for your help as always

     

     

  • HS_PDS's avatar
    HS_PDS
    Frequent Visitor
    7 years ago

    vjnvinod 

     

    Were you ever able to find a solution or workaround? We also have a similar issue regarding auto-populating filters and are interested.