Forum Discussion
Control 1 Visual with 2 slicers
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.
Hey v-xicai
So the Table SumOfErrors Looks something like this:
This is the Errors table I am trying to use a slicer:
And using this data I am trying to build visuals in Power Bi but I would like to be able to choose the vendors being show and select the Error type shown. For example I would like to select company1 and 3 but only show errors UT and CT. My problem is that I am unsure how I would select column using a slicer.
Let me know if this makes things anymore clear.
Thanks
Fixed picture, will look into request now.
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
You are a champion sir, I spent hours trying to do it my way but this works much better.
Thanks