Two different filters on query's/datasets

[Zork9999]

Hi,

I want to make a report regarding VM's info based on CPU and Memory with a slider on month's.

Also I want to have the computernames showed even there is no information in one of those tables/query.

So I got 4 tables/querys:

CPU info

- Computer

- Value

- Date/Time generated

- Month nr (extracted from date/time field)

- Month name (extracted from date/time field)

Memory info

- Computer

- Value

- Date/Time generated

- Month nr (extracted from date/time field)

- Month name (extracted from date/time field)

Manually i created the following tables

Months

- Month Nr

- Month name

Computer

-Computername

So the problem is that I can't use two filters, computername and month in my report.

Report should look like this

Hopefully you understand my problem.

Regards

Zork

[Datatouille · Accepted solution]

Hi @Zork9999

Your relationship between Months and Memory info exists but is inactive because of Bidirectional relationships !

This relationship mode is only available and (surprisingly) by default in Power BI Desktop.

If you want to activate your relationship between Months and Memory Info, double click on each relationship in the relationship view (or go to manage relationships) and turn cross filter direction for each of them from "both" to "single":

You can then Make the relationship active between Months and Memory info tables.

[Zork9999]

@Datatouille

Thank you very much, that did the trick!

One question more, is there an option to see the query in power BI. Like in SQL?

Regards

Zork