Filter Columns (Text) by Slicer

[MrNeverland]

Hey guys

I have a table with multiple categories and I need to filter them in the visual by slicer.

The table should be in one visual with all the data. And if a filter is selected it should filter the columns not the rows/values.

Filter Nutzung (filter rows): "Nutzung" that need to be filtered: easy with a typical slicer with the values from the original table.

Filter Gewerk (type of work) - Filter columns: there starts the problem there are multiple columns with the same type of work (red is one and green). The prefix to each name in each column is red = "Heizung" = "HEI". For green = "Kälte" = "KAE"

Filter Systeme - Filter columns: I assume this would be the same workflow as "Filter Gewerke".

I know there could be a workaround on this one and this is not the core of relational databases/modelling with primary keys.

I hope you know what my problem/goal is, otherwise let me know - thanks a lot in advance!

beste regards, MrNeverland

[lbendlin]

You already know where this is heading. Show your data model.

[MrNeverland]

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.

[lbendlin]

Read about USERELATIONSHIP . Show your data model.

[MrNeverland]

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

[lbendlin]

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.