Forum Discussion

Peter_Jeyaraj_I's avatar
Peter_Jeyaraj_I
Helper II
7 years ago
Solved

Derive Column based on Slicer selection

Hi All,    I want to change the dimension selection in a chart based on the slicer filter in POwer bi.. For ex.. i have a mapping with 2 different description per language like below     &...
Tips and Tricks
  • Peter_Jeyaraj_I's avatar
    Peter_Jeyaraj_I
    7 years ago

     thank you.. i created the many to many releationship by using the bridge table. 

    this way i created the relationship b/w my transaction to fail code mapping with duplicate entries ( 1 entry for eng and 1 entry for danish).  that solved my issue.. 

     

    more details refer below link

    https://www.seerinteractive.com/blog/join-many-many-power-bi/

     

PattemManohar's avatar
PattemManohar
Community Champion
7 years ago

Peter_Jeyaraj_I Could you please post your expected output as well ? If possible sample data that can be copied. 

Peter_Jeyaraj_I's avatar
Peter_Jeyaraj_I
Helper II
7 years ago

Here below i shared the sample screenshot

I have 3 different tables

1. Master ( Countof Failures measure available here )

2. Fail_Mapping ( Fail category & fail category d columns available here)

3. Language ( Lang field )

If i select english then the chart has to show the failures count by fail category 

If i select danish then the chart has to show the failures by fail category d. Hope this helps