Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Two slicers from one column

I have a scenario of using two slicers to filter data, below are the steps:   1. Create two slicers with same column (Which is easy) 2. Filter the visual based on both selections (This is returnin...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Yes v-qiuyu-msft, My reports has a page of Brands comparision side by side with multiple charts (for which I have edited Interactions), but in same page I have 2 charts which shows comparision in one visual (Multiline trends & Grouped barchart). 

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi Anonymous,

 

Firstly in a slicer visual, we can't control how many values can be selected by end users. You can consider create a new table which only have a table column contains two values, then use this column in the slicer visual, create a relationship with original table as well. 

 

Another good option is that you can use Visual level filter as I suggested optionally. After you save the report and publish to service, user view report by change different filters won't affect other user's results. 

 

Best Regards,
Qiuyun Yu