Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |