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 all,
I want to link 2 calendars to the same filter.
I have a table invoice. Containing all the invoices and it has an invoice date.
It also contains a shipment date
And it contains an amount
for example
invoice1
Shipment: 1/1/2018
Invoicedate: 3/1/2018
Amount: 100
Invoice2
Shipment: 2/1/2018
Invoicedate: 3/1/2018
Amount: 100
Invoice3
Shipment: 3/1/2018
Invoicedate: 4/1/2018
Amount: 100
I created one date table using dax. DateFilterTable = Autocalendar()
But I can't connect this table to both fields as a relation
So I switched to 2 date tables instead of DateFilterTable
Called shipmentdatefilter and invoicedatefilter
Now I need to create a graph wich visualize the folowing
Over a period of time the amount shiped on that day and the amount invoiced that day.
Should be something like
1/1/2018
Shipped: 100
Invoiced: 0
2/1/2018
Shipped: 100
Invoiced: 0
3/1/2018
Shipped: 100
Invoiced: 200
4/1/2018
Shipped: 0
Invoiced: 100
How to do this.
Of even if they are in 2 different graphs. I can pull this of.. But I need to add a slicer for both calendar tables. And If I change one the other one is not changed with it. So I need to set both filters manually.
PS. This is, of course, a fictive but simple example of the issue
Kind regards
Solved! Go to Solution.
Hi @Anonymous,
I would generate 2 tables one called Invoice the other called shipment. I would just copy your Invoice table that you have and call ti shipments. Then join those 2 tables to 1 date dimension on invoice date and shipment date respectively.
You can then generate the graph you want useing the date dimension.
You can connect multiple date fields to a date table, you just need to make sure that you use USERELATIONSHIP in the measures etc that involve whichever date field(s) are inactive
You can connect multiple date fields to a date table, you just need to make sure that you use USERELATIONSHIP in the measures etc that involve whichever date field(s) are inactive
Hi @Anonymous,
I would generate 2 tables one called Invoice the other called shipment. I would just copy your Invoice table that you have and call ti shipments. Then join those 2 tables to 1 date dimension on invoice date and shipment date respectively.
You can then generate the graph you want useing the date dimension.
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 |
---|---|
104 | |
96 | |
79 | |
65 | |
62 |
User | Count |
---|---|
147 | |
116 | |
104 | |
88 | |
65 |