Slicer

[Njordan]

Hi, I'm fairly new to working with Power BI. I was able to create multiple visiuals and slicers, however, the slicers are not working properly.  I have two slicers and two tables, i need the slicers to work independently and together to filter my visuals.  I checked my connections, i tried to sync the slicers as well and even use the advanced option but the the filter options in the slicers do not filter both visuals correctly.  Not sure what else today, any help/suggestions would be greatly appreciated

[v-yangliu-msft]

Hi  @Njordan ,

I created some data:

Table：

Table2：

The [date] column of Table and the [group] of Table2 are used as slicers, and they will affect each other.

Here are the steps you can follow：

1. You can select the slicer group and open Format-Edit interactions.

2. Click on the circle that appears in another slicer.

3. Select the slicer date, open Format-Edit interactions.

4. Click on the circle that appears in another slicer.

5. So that the two slicers will not affect each other.

Best Regards,

Liu Yang

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

[Njordan]

@v-yangliu-msft Hi, the edit interation options does not pop up for the slicer.  I have two separate datasets and i'm trying to link multiple slicers. All of the other slicers I have interact and filter correctly but, when I select this one slicer to drill down in the detail more, it does not work.

[ChrisMendoza]

@Njordan - Are you talking about being able to select from each slicer (selection item) as needed; CTRL + Left Click? Possibly you can share more about what you are experiencing.

[Njordan]

---

@ChrisMendoza wrote:

@Njordan- Are you talking about being able to select from each slicer (selection item) as needed; CTRL + Left Click? Possibly you can share more about what you are experiencing.

@ChrisMendoza Somewhat, I created two slicers to filter multiple tables.  The slicers will filter each other but not both tables. 

---

[Njordan]

@ChrisMendoza 

[ChrisMendoza]

@Njordan - Can you share your PBIX file, assuming non-confidential data? Otherwise, I think seeing your data model with the active relationships might help. Your attached images are rather small and I am unable to assist from what you have provided.

[Njordan]

@ChrisMendoza my apolgoies for the delay. 

https://tcco-my.sharepoint.com/:u:/p/njordan/ERrkV6ZXL8tIhRWy_Cjmg-MB0IQTSoqw27iq7uuIBnoFQg?e=jJnmLV

[ChrisMendoza]

I feel like this has something to do with the way the data type is saved (as Percentage). I feel like someone else might have better insight.

[Njordan]

@ChrisMendoza thank you! Can you please delete the post?

[ChrisMendoza]

I can't delete your post however, I did remove the images I attached.

[Njordan]

@ChrisMendoza okay, thank you very much for being patient and trying to assist me with my issue! 

[Njordan]

@ChrisMendoza  - Can you advise how to attach the file?  I've tried the URL etc and also inserting, nothing is working.

I have the PBIX report filtered for color#73.  The issue is the totals for the tables are not reflecting correctly for the color totals by CO object name.  Color 73 is in Finance & Management but the function totals only reflect the total values.  If you select the management CO object name the function time displays correctly but the function total does not.  It should be significantly less since the functoin total % is 5%.  Does this make sense?   

[ChrisMendoza]

You'll need to share via your own OneDrive, Box, DropBox, etc.

[Njordan]

sample