Forum Discussion

jozho's avatar
jozho
Regular Visitor
1 year ago

Indirectly dependent slicers

Hi,

sorry, this is my first post, hope this is the right place and my question will be understandable:

I have a fact table PricesWithTax with price per country and date (date/CTR/price euro/conversion rate/price local). If the country uses EURO as their currency, Exchange rate and price local equal 0.

Besides the countries, there are two clusters (European Union and Euro zone) included in the table. These values cannot be derived/calculated from the values of single countries, so I have to keep them declared as they would be single countries.

 

Now to my issue - there is a region slicer allowing to select single or multiple countries (or clusters). Selecting one of the clusters in combination with other countries makes no logical sense, therefore there is a warning built in, but no hard stop for the user, they can select any combination of countries or clusters, even meaningless. Selecting multiple countries (not clusters) is okay.

 

Based on the selection of the slicer I am filtering a chart. In the chart, I want to have the option (slicer?) to switch between the Euro and local currency, but I only want to show the local currency option in case one single country is selected that has local currency.

 

The full logic is - show the local currency option only if in the region slicer one single country, which is not one of the two clusters and has other than EURO currency, is selected. The non-Euro countries can be identified by min/max/sum of either exchange rate or local price >0, but I could even add a helper table with explicit information about countries and their currencies (would be even cooler to not show the switch with the title 'local' but with the respective currency abbreviation GBP, HUF, RON...).

 

I can't get it work - any ideas, suggestions, hints...?

Thanks in advance

13 Replies

    • jozho's avatar
      jozho
      Regular Visitor

      Hi Rita,

      thanks a lot for your fast response, sorry, I only noticed now there were answers from two different accounts and replied to the one from community support team.

      Please let me know if you can follow that thread or is it better to continue in this one...?

    • jozho's avatar
      jozho
      Regular Visitor

      Hi Rita,

      any news...?

      Thanks in advance

      Jozef

  • v-menakakota's avatar
    v-menakakota
    Icon for Community Support rankCommunity Support

    Hi jozho ,
    Thanks for reaching out to the Microsoft fabric community forum. 

    Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
    Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
    Please show the expected outcome based on the sample data you provided.
    How to provide sample data in the Power BI Forum - Microsoft Fabric Community

     

    Best Regards, 
    Community Support Team  

      

    • jozho's avatar
      jozho
      Regular Visitor

      Hi, thank you for the response - i created a simple model simulating the situation, it's available at my onedrive under this link SlicerModel.pbix

      There are the two clusters mentioned in my first post (EU, EUR), two countries that only have EUR as currency (AT and BE) and two countries with local currencies (CZ, BG).

      I also attached the helper table with countries and currencies, but it is not used so far.

      • v-menakakota's avatar
        v-menakakota
        Icon for Community Support rankCommunity Support

        Hi jozho ,

        Thank you for sharing the sample data, I appreciate your patience and apologies for the delayed response. Please check on to the pbix file which i have shared.

        If I misunderstand your needs or you still have problems on it, please feel free to let us know.   

        Best Regards, 
        Community Support Team.