Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Control 1 Visual with 2 slicers

Hello, I am trying to control 1 Visual with 2 slicers. The first one controls the companies(x axis) that appear on the Stacked Column Chart. The second controls objects that are in the stacks(y axis)...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi,

     

    In edit queries select UT, OT, BT and CT and click unpivot columns. You now get Attribute and Value. Then create a relationship between Attribute and Errortype and the slicers should work. 

     

    Screenshots below

     

    And here is the pbi file.

    https://1drv.ms/u/s!AgnVgd15_ye0hBnpo-dpJlRKyYpc

     

    Hope this helps, Goodluck.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Fixed picture, will look into request now.

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

 

In edit queries select UT, OT, BT and CT and click unpivot columns. You now get Attribute and Value. Then create a relationship between Attribute and Errortype and the slicers should work. 

 

Screenshots below

 

And here is the pbi file.

https://1drv.ms/u/s!AgnVgd15_ye0hBnpo-dpJlRKyYpc

 

Hope this helps, Goodluck.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous 

    You are a champion sir, I spent hours trying to do it my way but this works much better.

    Thanks