Forum Discussion
Date Issue (correlation?)
Hi everyone!
Eventhough new to Power BI, I'm managing issues quite well except this one...
I have two queries (xlsx) related with column SALES_CATEGORY. Both queries have a DATE column (formated the same way). I have a visual with (currency sum) data from both queries (SALES from 1st, PROCUREMENT from 2nd) and SALES_CATEGORY in Axis.
BUT when I create a slicer with DATE coming from Query 2, it filters only PROCUREMENT but not SALES.
(note that PROCUREMENT has values on Sep & Oct while SALES has values on Oct only).
I would GREATLY appreciate any help on that.
I'm attaching a link to the published report.
And I highly recommend the free video training "Introduction to data modeling for Power BI"
https://www.sqlbi.com/training/
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
3 Replies
And I highly recommend the free video training "Introduction to data modeling for Power BI"
https://www.sqlbi.com/training/
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
It took a while, but both these links were enlighting...
Everything works like a charm now. Thank you!
You need a date (dimension) table and a star-shema
Start here:
https://www.youtube.com/watch?v=gyvhM5eiT0U
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
