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.
Community SupportHi Anonymous ,
I am not sure what desired result would you want, could you please share your sample data or desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.
Best Regards,
Amy
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.