Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Filter Columns (Text) by Slicer

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

 

 

DAX
Filter
filter column
Slicer
Visual

5 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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's avatar
        lbendlin
        Super User
        2 years ago

        Read about USERELATIONSHIP . Show your data model.