What's the Power BI equivalent of Tableau's "show only available values" in a filter?
Say I have slicers for Main[Account] and Dates[Alias] - I want the Dates[Alias] slicer to only show "1" and "2" when I set the Main[Account] slicer to "B".
This seems like a very basic feature so I'm sure it must be achievable somehow?
Solved! Go to Solution.
If your data model is like your example then the slicers will cross filter. However, if you have two slicers each from a different dimension table connected both in a single filter relationship to a fact table they will not crossfilter.
This is because when one filter is applied it goes through the relationship to the fact table however as the other dimension table is on a single direction relationship the filter from the fact table will not propogate back up to the second dimension table.
The solution is either to have two way relationships between your dim and fact tables, this can have strange and unintended consquences so this is not advised.
Or you can try change the model such as merging dim tables or denormalising them into the fact table.
I am not totally sure I understood your problem, but when I add two slicers - One for Account and one for Day I get the expected result (attached in the screenshot)
Or did you mean do you wanted to add a slicer and then upon the slicer limit it to a few defined options?
Hmm, sound accurate - for me I have an extra Dates table that just has the distinct dates (i.e. one-to-many). Filtering for an Account in the main table will not back-propagate to the Dates table.
Does that mean the only solution is the very unclean approach of adding my date aliases ("Most recent" etc.) to my main table (and hence to millions of rows) instead of using a separate Dates table?
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.