Forum Discussion
Filter Columns (Text) by Slicer
You already know where this is heading. Show your data model.
hey lbendlin
you mean something like this?
the problem is, we have in the same column header different primaryKeys that we'd like to filter. The main goal is one table in the visual, which is the cause of the problem. Otherwise I would do some calculated tables for each system or type of work with the use column as primaryKey. The column names won't change in the future.
hope this helps.
- lbendlin2 years agoSuper User
Read about USERELATIONSHIP . Show your data model.
- Anonymous2 years agoNot applicable
hey lbendlin like my previous response (simple datamodel) the following are printscreens frin my model. Please clarify if this is not what you're looking for! thanks
- lbendlin2 years agoSuper User
As you mentioned further up you will need to spend time cleaning up and refactoring this data model. It might just be too complex for Power BI though. Consider using alternatives like Qlik, or breaking the business problem/data model into smaller pieces.