Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be 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

Reply
GrahamJH
Frequent Visitor

Slicer - No Style Option in "Slicer settings".

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.

GrahamJH_0-1730457066039.png

As above, no option change style to a list.  Stuck with tiles.

1 ACCEPTED SOLUTION
SamWiseOwl
Community Champion
Community Champion

Hi @GrahamJH 

Are you using the Slicer or the Slicer New.

SamWiseOwl_0-1730459135034.png

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.

View solution in original post

3 REPLIES 3
GrahamJH
Frequent Visitor

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.

SamWiseOwl
Community Champion
Community Champion

Hi @GrahamJH 

Are you using the Slicer or the Slicer New.

SamWiseOwl_0-1730459135034.png

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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.