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.
Hello. I want to create a table with a list of values.
I have this table with lines of consumption:
ID | AccountID | Name | Criteria
1 | 123 | Product A | Yes
2 | 123 | Product B | No
3 | 456 | Product A | No
4 | 456 | Product B | No
I want a table that returns:
(A list of all the Account ID with lines of consumption with Criteria "No" with the list of those products.)
Account ID | Name
123 | Product B
456 | Product A
456 | Product B
Solved! Go to Solution.
Hi @PDRTXRA ,
You can try this:
In the Power BI Desktop, select the table visual:
And then add the Name column and AccountID column:
And then select the slicer visual:
Add the Criteria column like this:
Choose No:
Is this the result you expect?
Hope this helps you.
Best Regards,
Community Support Team _Yinliw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @PDRTXRA ,
You can try this:
In the Power BI Desktop, select the table visual:
And then add the Name column and AccountID column:
And then select the slicer visual:
Add the Criteria column like this:
Choose No:
Is this the result you expect?
Hope this helps you.
Best Regards,
Community Support Team _Yinliw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
are you wanting a matrix visual? or actual table that ignores the yes's.
you can filter out in the visual pane, ie right hands side of visuals. filter criteria to no only, or you can always filter out the yes's in power query.
Proud to be a Super User!
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 |
---|---|
99 | |
99 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
106 | |
105 | |
86 | |
72 |