How to set Slicer values based on another slicer value selection

[Chari]

I have two Slicer In first is values, and Second slicer is range.

Values	Range
Value1	1 to 30
Value2	1 to 7
Value3	1 to 20

if we select Value as Value1, the range slicer should show 1 to 30.
 Value as Value2, then range slicer should show 1 to 7.
 Value as Value3, then range slicer should show 1 to 100.

-->The Range value is showing based on Values selection, but if i slect value3 and range 20. then if i chenge Values slicer to Valie2, it throwing an error, why because we don't have 50 Range in Value2.

Note: whatever range we selected in Range Slicer, all Values should display in Values slicer.

[v-yiruan-msft]

Hi @Chari ,

Whether your problem has been resolved? If yes, could you please mark your post as Answered? It would be helpful for the others in the community if they face the similar problem as yours. Thank you.

Best Regards

[v-yiruan-msft]

Hi @Chari ,

Base on your provided info, it seems the table visual can't work properly when check different slicer selections. Could you please provide the following info for further troubleshooting?

1. Please provide the error details by clicking "See details" link

2. Are the fields which applied on Values slicer and Range slicer from the same table?

3. Could you please share a simplified pbix file? You can refer the following link to upload the file to the community: How to upload PBI in Community

Best Regards

[muhammad_786_1]

Hi @Chari 

In my case, the slicers for Value and Range are working as expected, and I’m not encountering any errors as shown in the attached images. It might be an issue specific to your version or dataset.

Could you please share some sample data, so I can take a closer look.

Best Regards,
Muhammad Yousaf

LinkedIn