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 i have 3 table
Table1= Contact_Details[Date]
Table2=Engagement_Details[Date]
Table3=Calender[Date]
if i select a blank( Calender[date]), it shows values in a barchart.
if i select a particular date(Calender[date]), its not shows any values in a bar chart.
Want common date filter and it should associate with all other table.
Solved! Go to Solution.
I found the solution.
In data view all dates are present in date format..
but in powerquery all dates are present in datetime format.
after change the date column, datatime format into date format.
Association works.
What measure or column aggregation are you using in your chart?
Hai,
All are columns.
just i loaded the data from source(Table1 & Table2).
In powerbi just i create calender table(Calender = CALENDAR(DATE(2018,9,1),DATE(2021,12,31))) only.
Hi @Anonymous,
According to your snapshot, it seems like blank item(no matched) can display visual graph. I'd like to suggest you double check your relationships to confirm if they have correct mapping two tables.
For example: switch date slicer to between mode with a large date range to apply on visuals.
BTW, it will be help if you share some sample data for test.
Regards,
Xiaoxin Sheng
Please find the sample dataset follwing url
I found the solution.
In data view all dates are present in date format..
but in powerquery all dates are present in datetime format.
after change the date column, datatime format into date format.
Association works.
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 |
---|---|
112 | |
97 | |
85 | |
68 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |