Forum Discussion
Indirectly dependent slicers
Community SupportHi 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.
HI,
thank you very much for your support.
Maybe I deceived you with vague descripotion - I used the term 'country list' - but what I actually meant was a slicer on country column from the main fact table (prices).
You've got the solution partially, the currency slicer changes upon the selection on the other slicer, but I am not sure - either I don't understand your proposal completely, or it doesn't work exactly in a way I expect/need:
1) (significance high)
issue: you replaced the slicer from main fact table (prices) and replaced it with slicer on added dimmension DAX table - as a consequence, user can choose currency, not country. the prices chart is not filtered by the currency slicer (and can't be, because EUR currency has no unique assignement to a country)
hint: the user selects countries from the main fact table, they do not select currencies. the selection of countries filters the price chart and the map element that visualizes the selection. This selection should influence the appearance of the currency slicer.
2) (significance low)
if possible, I would prefer having the particular currency abbreviation shown in the currency slicer, not only the generic 'Local' expression - the local currency option is available only when exactly one country (with local currency) is selected, thefore local refers always to one particular currency
I hope this helps.
Thank you in advance for your feedback
Wishing you a nice day
- lbendlin
Super User
What should happen when the user selects both Austria and Switzerland?
Filters should ideally come from dimension tables.
Only EUR would be shown at selecting AT + CH
Logic:
CH has local currency, so if selected alone, EUR and Local (resp. CHF) would be offered. But since CH is selected in combination with other country, local will be hidden.
And yes, you are right - at the end I actually created Dim table Called CountryControl that feeds the slicer, one of the reasons being that in the fact table Euro zone and European Union are included as countries, which confuses the map visual control.
- v-menakakota
Hi jozho ,
If the issue still persists on your end, we recommend reaching out to our Power BI certified solution partners. These are highly experienced professionals who can provide in-depth technical assistance and offer tailored solutions based on your specific needs. You can explore the list of trusted partners here:Power BI Partners | Microsoft Power Platform
You’re always welcome to continue engaging with the community.
Best Regards,
Community Support Team.- v-menakakota
Hi jozho ,
We are following up once again regarding your query. Could you please confirm if the issue has been resolved through the Power BI certified solution partners ?
If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community.
Thank you.Hi,
no, sorry, I used all the time reserved for the issue with no solution at the end, so it's on a backburner for the time being.
If I manage to return to the topic and resolve it later, I'll definitely share the solution.
