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.
Hello,
I have a following situation:
Before, I used excel file which was always downloaded from our Sharepoint containing data regarding quality of production.
However, now I established a direct link to Sharepoint where we can directly fetch the data and connection from the Model view seems to be working well and everything matches the previous one.
The problem is in the fact that the filtering by date does not work. I used to filter by date with table which I build up from DAX code (date, date as integer, current week, current month, etc.) in addition my variables are correctly categorized (Date = date format, Amount of issues = Whole number with Sum per default).
Did anybody have a similar situation?
Id be happy to hear your experience and will be glad to provide more information in case needed.
Thank you in advance
BR,
Filip
Solved! Go to Solution.
I managed to solve it. It was actually due to the power query data types not being automatically recognised as usually from Excel.
However, many thanks for your will to help!
hi @Anonymous
First, you fetch the data from sharepoint directly, it is not "Direcr query", it is still "Import" like "I used excel file which was always downloaded from our Sharepoint containing data regarding quality of production".
https://docs.microsoft.com/en-us/power-bi/desktop-directquery-data-sources
Second, for your problem, you may try to keep cross filter direction is "Both"
or if there is something wrong in data format for the 'Calendar'[Date], 'NCR_db'[Datum],'NCR database'[Datum].
eg. "date as integer,""Date = date format,"
If you still have problem, please share a simple sample pbix file for us have a test, there should be something wrong in other.
Do mask sensitive data before uploading.
Best Regards,
Lin
Hi Lin,
Many thanks for your recommendations, however none worked out.
What I did try to do is to create dateasinteger to see if the connection would work, and it worked seamlessly. However, the problem stays since dateasinteger is text type of variable, and only dates and numbers can be continously charted on x-axis. I tried to repeat again the procedure as primarily planned, however does not work. All my dates are same format and I am really now confused.
hi @Anonymous
If possible, could you please share a simple sample pbix file for us have a test? That will be a great help.
Regards,
Lin
I managed to solve it. It was actually due to the power query data types not being automatically recognised as usually from Excel.
However, many thanks for your will to help!
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |