Forum Discussion
New Table
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
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.
2 Replies
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.
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.
