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

can post a pbix file?

Highlighted

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


@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

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

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors