Prepare Data for Chiclet Slicer

[CMC]

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?

[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.

[v-danhe-msft]

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

[CMC]

thanks 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