Two different filters on query's/datasets

Question

Hi,&nbsp;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&nbsp;(extracted from date/time field)&nbsp;Memory info- Computer- Value- Date/Time generated- Month nr (extracted from date/time field)- Month name&nbsp;(extracted from date/time field)&nbsp;Manually i created the following tablesMonths- Month Nr- Month name&nbsp;Computer-Computername&nbsp;&nbsp;So the problem is that I can't use two filters, computername and month in my report.&nbsp;Report should look like this&nbsp;Hopefully you understand my problem.&nbsp;RegardsZork&nbsp;&nbsp;&nbsp;

datatouille · Accepted Answer

Hi&nbsp;Zork9999&nbsp;Your relationship between Months and&nbsp;Memory info exists but is inactive because of Bidirectional relationships&nbsp;!&nbsp;This relationship mode is only available and (surprisingly) by default in Power BI Desktop.If you want to activate&nbsp;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"&nbsp;to "single":&nbsp;&nbsp;You can then Make the relationship active between&nbsp;Months and&nbsp;Memory info&nbsp;tables.

Forum Discussion

Two different filters on query's/datasets

2 Replies

Related content

Page Level filter for different groups

% of difference from previous rows in a group for large dataset for Power query

Requirements to run a query against a dataset on power automate

Different schema into different destination

How to manage large dataset in Power Query