Forum Discussion
Filter column based on 2-value combination from another table
Hello,
I have a table (Table1) with columns ID, Attribute, Value. This is a pivoted table of 200 columns and 3000 rows + an added index column.
Some Attributes may have the same range of Values. Values can be anything, numbers or string. I treat all data as categorical.
Step 1:
I want to select specific Attribute-Value combinations dynamically.
To do that I created a copy of this table (Table2) and created a hierarchical slicer with the Attribute as category and Value as sub category.
The problem is that the slicer has an "OR" logic.
To bypass this I thought of applying myself an "AND" logic and return a string of the desired IDs.
Is my approach correct ?? Is there a better alternative ??
Step 2:
Having the desired IDs from Table1, Iwant to filter the IDs from Table2. I also added a slicer that selects an Attribute from Table2 and a bar chart that plots the count of each value for the selected Attribute.
I need everything to be dynamic.
Any ideas/suggestions ??
THank you in advance.
4 Replies
- AnonymousNot applicable
Hi simple_user
Can you provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- simple_userFrequent Visitor
I made an example, but I have a stupid question.
How do I upload it ??
I am new to this forum.- fooddCommunity Champion
You can upload the PBIX file to a cloud storage service such as OneDrive, Google Drive, Dropbox, or to a Github repository, and then share a file’s URL.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523/highlight/true#M607150
This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.