cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Helper IV
Helper IV

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

can post a pbix file?

Highlighted
Helper I
Helper I

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

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

Highlighted
Helper V
Helper V

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


@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. 

Highlighted
Helper I
Helper I

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

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

 

Highlighted
Helper I
Helper I

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

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

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors