March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
I created a table with a single column containing the Fields of my main table using this M Query:
let
// Load your existing table
Source = AllResults,
// Get the column names of the existing table
ColumnNames = Table.ColumnNames(Source),
// Create a new table from the column names
ParameterTable = Table.FromList(ColumnNames, Splitter.SplitByNothing(), {"Table Builder"})
in
ParameterTable
I then create a Slicer using this table and the Table Builder field.
Switched to Format visual, expand Slicer settings.
As above, no option change style to a list. Stuck with tiles.
Solved! Go to Solution.
Hi @GrahamJH
Are you using the Slicer or the Slicer New.
If new swap to the old one.
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
Thanks Sam!
Spot on.
BTW. Do you happen to know why the New Slicer behaves like this? It seems to be a step backward.
Normally when the have "New" versions they are in testing.
I suspect they will become integrated later, we have had "New table" and it replaced the old one.
I could be wrong, the new one has a lot of flexability with images and formatting on the tiles.
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
Hi @GrahamJH
Are you using the Slicer or the Slicer New.
If new swap to the old one.
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
133 | |
90 | |
88 | |
64 | |
58 |
User | Count |
---|---|
202 | |
137 | |
106 | |
70 | |
68 |