Forum Discussion

nizaminzi's avatar
nizaminzi
Frequent Visitor
5 years ago

Dynamic Slicer Value Population

Hello All,   I have the below requirement.   We have currencies at three levels. Global - USD YEN Regional - USD YEN EURO Local - USD YEN POUNDS FRANC        The Currency Singl...
Need Help
Tips and Tricks
v-janeyg-msft's avatar
v-janeyg-msft
Community Support
5 years ago

Hi, nizaminzi 

 

I have not seen what you want to use the Currency slicer for from your description, if it is only used for presentation, it can be replaced by card, which can be dynamic.

Could you share some sample data for reference?So we can help you soon.

 

Best Regards

Janey Guo

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

nizaminzi's avatar
nizaminzi
Frequent Visitor
5 years ago

Please find attached the sample file. 

 

There are two tables.One for Region,Country and one for Currency.Currency is a disconnected table.

 

Country Key Country Region
JP Japan JAPAN
US USA AMERICAS
CA Canada AMERICAS
MX Mexico AMERICAS
FR France EMEA
IL Israel EMEA
IT Italy EMEA
NL Netherlands EMEA
PL Poland EMEA
DE Germany EMEA
AU Australia APAC
IN India APAC
MY Malaysia APAC
NP Nepal APAC
SG Singapore APAC
NZ New Zealand APAC
CN China CHINA

 


Currency

USD
JPY
EUR
POUNDS

 

we need to change currency table according to selections made on region and country from the region table.


Reagrds,

Nizam

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    5 years ago

    Hi, nizaminzi 

     

    I was very busy yesterday,but now I have checked your needs and I find some problems.

    First, I have reminded you in the last reply that it is impossible to dynamically change the value in sclier, because this is equivalent to dynamically changing the value of a column in your data source. So can you understand it?

    If you want to change dynamically, you can only use measure. Can you fully describe your reqiuirements and what you want the currency slicer to do? So I can give you a suitable workaround.Thank you.

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • nizaminzi's avatar
      nizaminzi
      Frequent Visitor
      5 years ago

      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.

      • v-janeyg-msft's avatar
        v-janeyg-msft
        Community Support
        5 years ago

        Hi,  nizaminzi 

         

        Do you want to prohibit users in the local area from choosing non-corresponding currency?

         

        Best Regards

        Janey Guo