Date Issue (correlation?)

[Thimios]

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.

https://app.powerbi.com/view?r=eyJrIjoiNGQxOTcyOWEtOTlmZS00Y2JjLWFhNDQtODZjZDQ0ZTc5YzAwIiwidCI6IjNjO... 

[mwegener · Accepted solution]

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.

[Thimios]

It took a while, but both these links were enlighting...

Everything works like a charm now. Thank you!

[mwegener]

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.