Forum Discussion
Helper IPrepare Data for Chiclet Slicer
I'm connecting to a tabel in a website, when the data loads in Power BI I have two rows called Feature, the top row which includes Self Paced & Instructure lead is what I want I to use in the Chilcet Slicer
The data looks like this in Power BI
Now I want to be able to toggle those selec as per below: Any ideas?
5 Replies
v-danhe-msftMicrosoft Employee
Hi CMC,
Based on test, you could to below step in query editor:
Transpose your data:
Promote the headers:
Apply it and now you could use the Feature_1 as slicer to show all items:
Regards,
Daniel He
CMCthanks get me part of the way, Ideally want the below layout though. Need to swap the headers for the rows
- v-danhe-msft
Hi CMC ,
Could you mean that you want to use the column as headers in your visual? If so, you could use the Matrix table:
Sample data:
Create a matrix visual:
Regards,
Daniel He
- v-danhe-msft
Hi CMC ,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?
Regards,
Daniel He
- CMC
Not resolved.