Forum Discussion
Marketplace Filter Not Showing Options When Selecting Two Non-Overlapping Date Periods
I'm encountering an issue in Power BI where the Marketplace slicer does not show any selectable options when I filter two non-overlapping date ranges.
Even though data for the marketplaces exists in the underlying table, the slicer becomes empty unless the selected date ranges overlap. It seems that when two separate time filters are applied, the marketplace slicer cannot resolve any valid entries due to the lack of shared dates.
This behavior is affecting the usability of the report, as users cannot explore different time windows in comparison without losing the ability to filter by marketplace.
Could you please assist in identifying a fix or a recommended modeling approach to ensure that the marketplace filter remains functional when comparing disjoint time periods? Thanks
Hi ShUr674lcw,
Thank you for reaching out to the Microsoft fabric community forum.
I’ve reproduced your scenario in Power BI based on your description using two non-overlapping date slicers (e.g., 01/01/2025 - 30/01/2025 and 01/12/2024 - 31/12/2024) along with a Marketplace slicer.I was able to achieve the expected output, where the marketplace slicer remains populated and functional, even when the selected date ranges do not overlap.
- Created two disconnected Date tables:
- One for the current period
- One for the comparison period
- Built custom DAX measures to filter sales based on each date selection.
- Used a calculated table to populate the Marketplace slicer so that it considers data from both selected periods.
- Connected a matrix visual to display sales from both periods by Marketplace.
Output:Please find the attached .pbix file with the working example. You can explore the model, DAX, and slicer behaviour directly.
If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.
4 Replies
Hi ShUr674lcw,
Thank you for reaching out to the Microsoft fabric community forum.
I’ve reproduced your scenario in Power BI based on your description using two non-overlapping date slicers (e.g., 01/01/2025 - 30/01/2025 and 01/12/2024 - 31/12/2024) along with a Marketplace slicer.I was able to achieve the expected output, where the marketplace slicer remains populated and functional, even when the selected date ranges do not overlap.
- Created two disconnected Date tables:
- One for the current period
- One for the comparison period
- Built custom DAX measures to filter sales based on each date selection.
- Used a calculated table to populate the Marketplace slicer so that it considers data from both selected periods.
- Connected a matrix visual to display sales from both periods by Marketplace.
Output:Please find the attached .pbix file with the working example. You can explore the model, DAX, and slicer behaviour directly.
If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.Hi ShUr674lcw,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.
Thank you.
Hi ShUr674lcw,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi ShUr674lcw,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.