Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there,
I'm sure there is a simple answer to this, I'm just not 'developer' inclined to work it out.
I have a dashboard that has visuals being sourced from multiple excel datasets. I need to filter the data according to date, and I don't know how to marry the Date Column from one data source to the Date Column of another, so that when I select a date range, all the visuals update accordingly (and correctly), regardless of where the data is housed.
Any ideas?
Many thanks
Justin
Solved! Go to Solution.
Hi @weldonjustin ,
The dashboard cannot be sliced and filtered.
Please consider MahyarTF's suggestion. You need to recreate a report that connects to all data sources (you can put all excel files in one folder and connect this folder), create a common date dimension table and use date column slices from the date dimension table.
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Hi @weldonjustin ,
The dashboard cannot be sliced and filtered.
Please consider MahyarTF's suggestion. You need to recreate a report that connects to all data sources (you can put all excel files in one folder and connect this folder), create a common date dimension table and use date column slices from the date dimension table.
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Hi,
Create the Date Dimension and link the particular table to that based on the Date column, then use date dimension to develop the slicer :
This is the link that you could get the date dimension :
Thank you for your response. I am going to research this and try implement it. From what I understand, you're saying that I should create a different datasource for the actual slicer/filter, and then create the relationship between that source and my excel spreadsheets?
Yes, you are right, need to create the date dimension, make a proper relationship, then develop the slicer base on the New date Dimension
Thanks your Kudos
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |