Forum Discussion
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
- Ritaf1983
Super User
Hi jozho
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523- jozhoRegular 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...?
- jozhoRegular Visitor
Hi Rita,
any news...?
Thanks in advance
Jozef
- v-menakakota
Community 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- jozhoRegular 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
Community 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.