Forum Discussion
Slicer Not Working Correctly with KPI Visual
Hi,
I have a Slicer that is listed by Area which comes from table Appts. This will change the number of bays free in a KPI visual eg GD = 1931, DA = 2000 that works.
I have KPI that has total bays which states 2061 in table BAYS.
Both tables are joined through BAYID header.
Problem I have is
1) When clicking on the slicer the KPI with total bays does not change, it stays at 2061. Where it should change on the slicer
I have a feeling I have to include a Filter DAX so this KPI will change but I maybe barking up the wrong tree
Thanks
Alex
Hi villa1980
Have you checked the direction of the connection between your two tables?
The table will only be affeted by your slicer if you use the correct direction.
Go to the modeland make sure that the small arrow point from the table with the slicer info down to the table you want to filter with the slicer.
You can change the relationship between the two tables by right clicking on the line between the two tables.
I hope this help and solved your problem. 🙂Hi Thomas,
Thank-you for the quick reply.
That has worked, I had the arrow pointing the wrong way.
2 Replies
Hi villa1980
Have you checked the direction of the connection between your two tables?
The table will only be affeted by your slicer if you use the correct direction.
Go to the modeland make sure that the small arrow point from the table with the slicer info down to the table you want to filter with the slicer.
You can change the relationship between the two tables by right clicking on the line between the two tables.
I hope this help and solved your problem. 🙂Hi Thomas,
Thank-you for the quick reply.
That has worked, I had the arrow pointing the wrong way.