Slicer Less or Equal with different data from Dropdown

[gustavoowagner]

Hi,
I'm having a problem with Slicer visual. The problem doesn't make much sense in my opinion.

I was trying to create a dynamically slicer for Consultants that they can adjust prices about commodities to see the gross margin for your clients.

In this process, I created a table with specific prices for each commodity. So I started with soybean and corn. Soybean with prices that comes 0 to 180.00, and corn 'til 100.00, cuz these commodities have a huge difference in prices.

Also, I was creating the visualization with a comm filter to select previously just one, then the slicers brings the values just from that unique comm.

So, if I filter Soybean, the slices comes between 0 to 180, and if I select corn, brings 0 to 100

Using the visual slicer, I got this result when I use the "Dropdown" style, but I wanna use "Less than or equal to", and then the filter wasn't respected.

Dropdown:

Less or Equals to: 

Is it correct or a bug from this visual? Someone already had a problem like that?

And database is like that:

 

[lbendlin · Accepted solution]

Eliminate the slicer. Use the Filter Pane instead. It allows for the advanced filtering you are looking for, and it frees up screen real estate.

[v-ssriganesh]

Hello @gustavoowagner,
I hope the information provided has been useful. Please let me know if you need further clarification or would like to continue the discussion.
If your question has been answered, please “Accept as Solution” and Give “Kudos” so others with similar issues can easily find the resolution.
Thank you.

[v-ssriganesh]

Hello @gustavoowagner,

Just checking in have you been able to resolve this issue? If so, it would be greatly appreciated if you could mark the most helpful reply accordingly. This helps other community members quickly find relevant solutions.

Thank you.

[v-ssriganesh]

Hi @gustavoowagner,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to @danextian & @lbendlin for sharing valuable insights.

Could you please confirm if your query has been resolved by the provided solution? If so, please mark it as the solution. This will help other community members solve similar problems faster.

Thank you.

[danextian · Accepted solution]

Hi @gustavoowagner 

The simplest method is to use the filter pane but if you want it done via a visual, try Filter by PowerViz https://appsource.microsoft.com/en-us/product/power-bi-visuals/truvizinc1674781244292.filter-by-powe... 

[lbendlin · Accepted solution]

Eliminate the slicer. Use the Filter Pane instead. It allows for the advanced filtering you are looking for, and it frees up screen real estate.