Forum Discussion
Slicer not working
I have taken data from share point and S Q L Server in power bi, and created measures and visuals as per requirement. Now I want to slice data by date slicer but the slicer should be only one for both the data. So for that I have used calendar auto() to create a date table and connected to share point and S Q L server data's date column to create relationship. As i put the calendar auto() into slicer to slice data slicer wont work or the data remains same it wont slice can anyone help me for that.
Anonymous , hope, you have joined the date of date table with the dates of you tables from sharepoint and SQL
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
2 Replies
Anonymous , hope, you have joined the date of date table with the dates of you tables from sharepoint and SQL
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
. Refer :radacad sqlbi My Video Series Appreciate your Kudos.Hi Anonymous,
Can you please share some more detailed information about these? They will help us clarify your scenario and test to troubleshoot.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng