Forum Discussion
Filtering report using USERELATIONSHIP measures with Charts
Hi there, I have created a report using 2 tables, one of Orders Created and other one of Open Orders. I want to show 2 charts, one of orders created by date of creation (Orders Created) and othe...
Anonymous
in your case you need to have 2 seperate date tables. and each table connects to each column
and each visual reads from its respective datetable
date table _document
date table_delivery
or simpler approach L
in the bar chart visuals, for the first visual ( document date) , read its date from the fact_table[document_date]
and for the second bar chart visual read (delivery_date) from the fact_table[delivery_date]
instead of the dimdate table .
let me know if this works for you .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠