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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
StolzHerz
Helper I
Helper I

Chiclet Slicer v1.4.5: Property "Show Disabled" not working?

Hi 

 

I use the chicletSlicer.1.4.5.0.pbiviz in Power BI Desktop (optimized for Power BI Report Server June 2017), and connect to a SSAS Tabular model.

 

The slicer has a property "Show Disabled" with options "Inplace", "Bottom", "Hide"

Can it be that this propery has no effect? Always all Dim-items are available in the slicer, independet whether they have corresponding Facts-items or not.

 

When i connect the same SSAS Tabular model with Excel 2013, and add a slicer there, unused Dim-items are disabled.

 

Greetings, Stolzi

5 REPLIES 5
KumarDarmesh
Helper IV
Helper IV

can post a pbix file?

Hi

 

I have only files with Connection to a local Analysis Server (SSAS Tabular), can't post one sorry. Does the property "Show Disabled" has an effect in your pbix files?

 

Greetings, Roli


@StolzHerz wrote:

Hi

 

I have only files with Connection to a local Analysis Server (SSAS Tabular), can't post one sorry. Does the property "Show Disabled" has an effect in your pbix files?

 

Greetings, Roli


I'm having the reverse issue i.e. no matter what option I choose in Show Disabled, it always filters out any options that don't have data. Ideally, when I select In-Place, I was hoping all the values would just show in place but disabled. 

Hi Vickyd

 

It give two different data model "styles":

 

  • You have two tables, a Dim and a Fact table with a relation <-- I have this model "style"
    • In the chart, data from the Fact table is displayed
    • The data is filtered by the Dim Table (Chiclet Slicer)
    • --> In this case, the Slicer shows always all items from the Dim table, independently if they have corresponding rows in the Fact table.
  • You have only one table, Fact and Dim values are both in this table
    • The Slicer is built from a field from this table
    • --> In this case, the Slicer shows only items which exists in the table (it is the oly source, the slicer can't have more items...)

What type of data model do you have?

 

Grettings, Roli

 

Hi

I got this Feedback from one of the GitHub contributors:

https://github.com/Microsoft/PowerBI-visuals-ChicletSlicer/issues/41#issuecomment-344970826

"Yes, you're right, latest version of ChicletSlicer doesn't support highlighting anymore.
So "Show Disabled" options doesn't work, it will be removed in the next version of the visual."

That are really bad news...

Greetings, Stolzi

 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors