my date slicer won't interact with my table and visuals from other

[emmasd]

Hello,

I have the below columns:

and the below visuals:

When I select a year nothing changes as below:

and the relationship is as below:

I need the total debt to change when I select a year.

Any advice?

[AnkitaaMishra · Accepted solution]

Hi @emmasd , 

Please make sure that the below pointers are implemented :
1) Date Dimension table is connected with Annual BS table on DATE column as one to many relationship
2) Could'nt see Year column in DATE Dimension Table : you can create a year columnn by implementing below DAX and use it in the slicer 

This should resolve your issue.
Please let me know if this works for you or share more details about your problem.

[vigneshba · Accepted solution]

@emmasd

- First Can you provide the details on how Date dimension table and Annual BS table is connected? If Date and Annual BS is connected directly or Date and Annual BS tables are connected via Information table, If so what is the key column which you create relationships between Date and Information, and between Information and Annual BS

- There is option in Power Bi to disable and enable filter interactions with other widgets. Please make sure if you had disabled that my mistake. But I hope it shouldn't be. Please follow below steps to disable and enable the filter interactions

In the Power BI reports page there are a lot of slicers in use. These slicers can be made to interact (or) not interact with certain visuals using "Edit Interactions".

Follow along to achieve this:

To disable slicers

Step 1:

Click on the slicer whose impact you do not want on a particular widget.

In this example, I do not want "DEPARTMENT" slicer to affect "Under skilled by Department" chart in the Performance Power BI dashboard.

So, click on the Department slicer and from the ribbon on top click on Format and then on Edit Interactions.

Step 2:

Once you click on "Edit Interaction", on all the visuals and slicers on the Dashboard, two icons will appear that allows you to choose whether the particular slicer or filter (as selected in step 1) should impact the visual or not. 

Meaning, you can edit the interaction made by a particular slicer on any visual present in that report page.

To disable interaction to any visual, click on the "stop" button which is visible on every visual. In  our example, it is for the "Unskilled by Department" chart.

To enable slicers

Follow the same steps as above in choosing the slicer whose interaction you want "enabled" on any visual.

Click on Edit Interactions and the choose the "Filter" option that appears on top to enable the slicer to affect the visual.

[AnkitaaMishra · Accepted solution]

Hi @emmasd , 

Please make sure that the below pointers are implemented :
1) Date Dimension table is connected with Annual BS table on DATE column as one to many relationship
2) Could'nt see Year column in DATE Dimension Table : you can create a year columnn by implementing below DAX and use it in the slicer 

This should resolve your issue.
Please let me know if this works for you or share more details about your problem.