Filters

Hey Paul

Apologies for coming back late. But Basically as mentioned earlier I have a small subset of adventure works database which has tables like dimcustomer,dimgeography,dimproduct,dimproductcategory,dimproductsubcategory,factinternetsales. 

I am creating a visual which is top 10 customer per sales amount per region

and what I want is 

If i have a french customer then I want frenchproductcategorylabel to show up, if english then english. This can be achieved in sql by putting a case statement like 

case when b.CountryRegionCode = 'FR' then f.FrenchProductCategoryName else f.EnglishProductCategoryName end as 'ProductCategory',

I am not sure how to achieve this in power bi. 

I dont know how to attach .pbix file in this community as i am very new to power bi and this community.Hope I am clear in the requirement 

Screenshot

screenshot

for example adriana gonzalez, she is french customer, so i want the french productcategory detail label to show up, for Jordan turner I need english product category detail label to show up.  I am using matrix to show the visual.