Dynamic Slicer Value Population

Hi v-janeyg-msft ,

I understand.So from your explanation I see that calculated columns approach is not possible.

My exact requirement is as follows.

• We have end users belonging to many regions accross the world.
• We have USD as our base measure and we convert the currency to other currency as the currency slicer changes.This currency slicer has both regional and country currency.
• For example if user selects JPY then we apply the conversion rate of USD to JPY and the report will show measures in JPY.

Requirement

• The tricky scenario here is that I want to show only certain currency options in the currency slicer when an user selects particular region and country.
• Default currency options should be USD and JPY and more currency options should be available as the user starts selecting individual regions and countries.
• For example if an user selects Europe in region then the currency slicer should have only USD,JPY and EUR.
• If he selects One country example england in europe then slicer should have USD,JPY,EURO and POUNDS.
• When all regions and all countries are selcted we should have only USD and JPY.
• The currency filter should be single select and by default USD will be already selected

I hope this is clear.If a workaround is possible then please suggest.