Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
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
Not resolved.
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
thanks get me part of the way, Ideally want the below layout though. Need to swap the headers for the rows
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