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.

rohit1991's avatar
rohit1991
Super User
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.

  • geetika3110's avatar
    geetika3110
    Frequent Visitor
    8 months ago

    Thank you so much for the quick response. Highly Appreciated