cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SQL_McOLAP
Frequent Visitor

Drop Down Slicers Keep Reverting To "All" In Their Display. Bug?

Hi -

 

We have some reports where end users can select any ad-hoc measures (up to 4) in our SSAS tabular cube that they desire.  Each have their own slicer.  The four slicers point to four unrelated tables in the tabular cube that are just a selection of hard-coded measure names, for instance:

 

Select "measure name" AS [Ad Hoc 1]

UNION ALL

Select "another measure name" AS [Ad Hoc 1]

etc....

 

We've got a lot of cool dynamic charting and matrix visuals going on, but what's frustrating is that when end users select items from other slicers after having made selections in these four slicers, these four slicers revert to "All" in the display, even though their selection remains in the slicer.  What's even more confusing is that the "Show All" Selection Control of these slicers is set to Off (with "Single Select" set to On) as we force them to select just one valid measure in each.

 

This is EXTREMELY confusing for our end users.  When they go back to those slicers and hit the down arrow, it immediately pulls up and displays the selection they had already made, but they shouldn't have to do this.

 

Why does this behavior occur?  Is it a bug?  Is there a way to work around this?

 

Thanks!

 

-Phil (SQL McOLAP)

3 REPLIES 3
Community Support
Community Support

Re: Drop Down Slicers Keep Reverting To "All" In Their Display. Bug?

@SQL_McOLAP,

 

I can not reproduce it. You may create a support ticket.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sushmach109 Helper I
Helper I

Re: Drop Down Slicers Keep Reverting To "All" In Their Display. Bug?

Hi Team,

 

I am also facing the same problem.I want to display the lastest month but it is showing ALL and then i have to select the month.I need to show to the default as month name instead of ALL.

 

Please help me and revert me ASAP.

Highlighted
Sushmach109 Helper I
Helper I

Re: Drop Down Slicers Keep Reverting To "All" In Their Display. Bug?

Capture.PNG

 

As shown in the image ,the dropdown is taking "ALL" instead of "MAY".

I want to set the value of month as default and remove ALL.How to fix this.

Please can anyone one help me in fixing this.

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors