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 have a general ledger material which looks following.
Document number | Line number within document | Amount | GL account number | Account name |
1 | 1 | -10.00 | 30 | Sales |
1 | 2 | 5.00 | 25 | AR |
1 | 3 | 5.00 | 22 | VAT |
2 | 1 | 8.00 | 25 | AR |
2 | 2 | -4.00 | 30 | Sales |
2 | 3 | -4.00 | 30 | Sales |
3 | 1 | -3.00 | 30 | Sales |
3 | 2 | 3.00 | 35 | AR |
What I would like to do is select account "Sales" from a filter for example and then see all rows from documents that include postings to selected sales account. Currently I will only see the lines that are actually posted to sales account but not the other lines of the document. Am I able to do this in Power BI? In Qlikview this can be done by using button with action to select all lines fulfilling the criteria.
Thanks!
@jvu wrote:
Hi,
I have a general ledger material which looks following.
Document number Line number within document Amount GL account number Account name 1 1 -10.00 30 Sales 1 2 5.00 25 AR 1 3 5.00 22 VAT 2 1 8.00 25 AR 2 2 -4.00 30 Sales 2 3 -4.00 30 Sales 3 1 -3.00 30 Sales 3 2 3.00 35 AR
What I would like to do is select account "Sales" from a filter for example and then see all rows from documents that include postings to selected sales account. Currently I will only see the lines that are actually posted to sales account but not the other lines of the document. Am I able to do this in Power BI? In Qlikview this can be done by using button with action to select all lines fulfilling the criteria.
Thanks!
Your question is not quite clear for me, do you mean that, say if "Sales" is selected, supposing that the correlated column "Document number" is 1, the show all the rows which have "Document number"=1? If so, you can simply do that with two slicers, just diable the interaction between the first slicer and table visual.
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 |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |