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

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.