Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |