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 

 

It’s my pleasure to answer for you.

According to your description,I think dynamic slicer value is not feasible, but you can use a measure in the card to achieve a similar result.

Like this:

Measure =
SWITCH (
    TRUE (),
    NOT ( ISFILTERED ( 'Table 1'[Country] ) ) && NOT ( ISFILTERED ( 'Table'[Region] ) ), "Currency- USD JPY",
    SELECTEDVALUE ( 'Table'[Region] ) = "EMEA"
        && NOT ( ISFILTERED ( 'Table 1'[Country] ) ), "Currency - USD JPY EUR",
    SELECTEDVALUE ( 'Table'[Region] ) = "EMEA"
        && SELECTEDVALUE ( 'Table 1'[Country] ) = "England", "Currency - USD JPY EUR POUNDS",
    NOT ( ISFILTERED ( 'Table'[Region] ) )
        && "England"
            IN DISTINCT ( 'Table 1'[Country] )
                && "France"
                    IN DISTINCT ( 'Table 1'[Country] )
                        && COUNTROWS ( DISTINCT ( 'Table 1'[Country] ) ) = 2, " Currency -USD JPY EUR",
    "AMERICAS"
        IN DISTINCT ( 'Table'[Region] )
            && "EMEA"
                IN DISTINCT ( 'Table'[Region] )
                    && COUNTROWS ( DISTINCT ( 'Table'[Region] ) ) = 2
                    && COUNTROWS ( DISTINCT ( 'Table 1'[Country] ) ) > 1, "Currency - USD JPY"
)

Here is my sample .pbix file.Hope it helps.

If it doesn’t solve your problem, please feel free to ask me.

 

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

v-janeyg-msft 

 

Thanks for the reply!

 

But I was looking for a different solutionI should have represented data in a better way.

 

My requirement is when i select region EMEA and country all, then currency slicer should be like below.

 

Currency Slicer

  • USD
  • JPY
  • EUR

This should give us an option to select one currency.

 

If I have selected multiple regions, then my currency filter should be like below.

 

Currency Filter

  • USD 
  • JPY

I hope I am clear here!

  • 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.