Forum Discussion
Derive Column based on Slicer selection
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/
Hi Peter,
how your language table is connected with base data table. , there can also achieve this using this approach.
Name of the table is Date(2) .
- Unpivot your table for Fail_Category and Fail_category_D
- create measure 'Count' = COUNT('Data (2)'[Value])
- drag object 'Value' to Axis and measure Count into Value
Slicer :
Create slicer using 'Value' field. ( you can change the name for category to english and Danish if needed)
Hope this helps
SS