The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hi,
My data model looks like this:
I'd like to visualize my longitude (dfRaw[lng]) and latitude (dfRaw[lat]) data on a map (both in decimal fomat eg. 14,2387 and 11,6790) .
With a date slicer (Input NewDate[Date]) the map should get filtered and should only show those position data that occure in this timeframe. A second filter is used to filter the dfVcl[vin_short] (String). Based on this I created my data model as shown above. It is to mention that [Date] and both [Date_Short] are all in the same formt (Date type = Date & Format = Short e.g 22.03.2022)
Now the problem: The Map only gets filtered by the second filter (vin_short) but doesn't respond to the date filter. To make this more clear here another picture.
Do you know this problem and kow how to fix it?
..
@Janica123 , Make sure date short joining with date table is having data type date. Ideally, a filter new date table will filter dfRaw table.
But filter from DfShift will not. So make sure date filter is from new Date tbale
thank you @amitchandak for your response.
All the date columns are in data type Date and the same format (short). The input for my date slicer is comming from the NewDate table (column Date) but it does not filter my map :((
User | Count |
---|---|
14 | |
12 | |
7 | |
6 | |
5 |
User | Count |
---|---|
28 | |
19 | |
13 | |
7 | |
5 |