Forum Discussion

geetika3110's avatar
geetika3110
Frequent Visitor
8 months ago
Solved

Data modelling for Slicer

Hi All, Need your support. I need to make a customer profile dashboard where there is certain information with respect to customer projects, e.g., type of resources, duration, etc., for a total of 2...
Need Help
  • rohit1991's avatar
    rohit1991
    8 months ago

    Hii geetika3110 

     

    Power BI slicers work only when the thing you want to filter appears as rows in a single column.

    Unpivot the customer columns in Power Query

    1. Go to Power Query >> select all customer columns (A, B, C, D, E…).
    2. Right-click >> Unpivot Columns.

    Now Customer becomes a proper dimension and can be used in a slicer.

anmolmalviya05's avatar
anmolmalviya05
Super User
8 months ago

Hi geetika3110 , slicers in Power BI cannot directly filter matrix columns.

They filter fields coming from your data model.

 

Right now, your Customer values (A, B, C, D…) are represented as columns in the table, which makes them not filterable by slicers.

You must unpivot (normalize) the data.

Once customers become a single field in rows, you can:

 

  • Add Customer to a slicer
  • Add Customer as Columns in the matrix
  • The slicer will filter the matrix correctly