Forum Discussion
How to set Slicer values based on another slicer value selection
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.
3 Replies
muhammad_786_1Solution Supplier
Hi Anonymous
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 YousafHi Anonymous ,
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