cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CMC Frequent Visitor
Frequent Visitor

Prepare 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

 

image.png 

 

The data looks like this in Power BI

 

image.png  

 

Now I want to be able to toggle those selec as per below: Any ideas?

 

image.png

5 REPLIES 5
Community Support Team
Community Support Team

Re: Prepare Data for Chiclet Slicer

Hi @CMC,

Based on test, you could to below step  in query editor:

Transpose your data:

1.PNG

 

Promote the headers:

1.PNG

Apply it and now you could use the Feature_1 as slicer to show all items:

1.PNG

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
CMC Frequent Visitor
Frequent Visitor

Re: Prepare Data for Chiclet Slicer

thanks get me part of the way, Ideally want the below layout though. Need to swap the headers for the rowsimage.png

Community Support Team
Community Support Team

Re: Prepare Data for Chiclet Slicer

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:

1.PNG

Create a matrix visual:

1.PNG

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: Prepare Data for Chiclet Slicer

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
CMC Frequent Visitor
Frequent Visitor

Re: Prepare Data for Chiclet Slicer

Not resolved.