Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hey everyone
I'm new to PowerBI and was wondering how to apply DAX filters.
I have created a Matrix Visual based on some field from one table.
The columns consist of item categories and rows are sales order IDs.
OrderID | Computers | Monitors | Laptops | Total |
123 | £2,490.00 | £2,490.00 | ||
124 | £3,422.00 | £3,422.00 | ||
125 | £2,430.00 | £212.00 | £2,642.00 | |
126 | £420.00 | £420.00 |
Is it possible to for example only show the rows where there is a value in Laptops, or when an sales order has both Computers and Monitors?
I feel like it's a very basic thing, yet I am unable to solve this.
Many thanks
Hi @WTR,
You can go the Filters pane and add fields from your data. So let's say you want to see rows only if there is a sale in Laptops then set Categories to Laptop and so on, based on your requirements.
Did I answer your question? Mark this post as a solution if I did!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI
Hey Shaurya,
This still doesn't fix my problem. Perhaps I didn't write down my issue properly.
Assume the following table:
OrderID | Computer | Monitors | Laptops | Accessoires | Software | Total |
123 | 2245 | |||||
124 | 2567 | 124 | 50 | 10 | ||
156 | 250 | 10 | 50 | |||
167 | 250 | |||||
178 | 1202 | 199 | 59 | |||
198 | 990 |
I want to display only the rows where there's a value in atleast Computer AND Monitors. (other combinations could eventually also be applied.)
The result I'm looking for is:
OrderID | Computer | Monitors | Laptops | Accessoires | Software | Total |
124 | 2567 | 124 | 50 | 10 | ||
178 | 1202 | 199 | 59 |
Is this possible?
Hi @WTR ,
Are the data you provided the results presented in the matrix? Is it possible to provide the original table so that your matrix can be reproduced locally?
Best Regards
Lucien
User | Count |
---|---|
70 | |
70 | |
34 | |
23 | |
22 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |