Slicer with filter not working proparely

[Anonymous]

Hello,

I have very simple datamodel (factSales and dimTime - screenshot below). When I use slicer for Month it filters sales proparely, but when I put filter on a slicer (for example I only want allow users to see months 1-6) it stops working on the maximum available month. Please see video below.

https://www.loom.com/share/ae4c63f144404eb68a9f345c1cd6b01d

Can someone explain this behaviour? Is it intentional?

Is there any workaround?

[v-yalanwu-msft]

Hi, @Anonymous ;

Is your problem solved? If so, Would you mind accept the helpful replies as solutions? Then we could close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,

Community Support Team_ Yalan Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi, @Anonymous ;

This design does have a slight disadvantage, but when you set the selection to the maximum 5, it can't  kown whether your slicer is selected or not, because the default slicer is displayed the same way;
So there are two ways:
1. You need to manually enter 5, which is equivalent to confirming the use of slicer.

2. Keep the filter conditions of slicer and card consistent.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@Anonymous Cannot think of anything, maybe change slicer to drop-down or list rather than in between (slider)

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[parry2k]

@Anonymous seems like a bug, I will open a support ticket.

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Anonymous]

Thanks @parry2k maybe do you have any workaround for this in mind?