Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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

bodxisatva

Dropdown slicer malfunction when used for OLAP cube hierarchy fields

Submitted by on ‎07-03-2023 07:36 AM

Hi,

 

We are having an issue and I am not sure what might be the reason. When we use a slicer in a dropdown mode for the hierarchy fields (or the entire hierarchy) from OLAP cube (haven't tested this with Tabulars) we see a malfuntion as it changes the displayed text from hierarchy leaf value to hierarchy leaf code, when some other slicer selection chnages.

 

Slicer settings:

Capture01.PNG

 

Capture02.png

 

Here is how it looks:

1. Select a hierarchy level in the affected slicer

Capture03.PNGCapture04.PNG

 

2. Change selection in other slicer

Capture05.PNG

 

3. Here is what now displayed instead of value at slicer using hiearchy

bodxisatva_0-1687517610146.png

 

This doesn't happen when slicer is in Vertical List mode.

 

Stan

 

Status: Investigating
See more ideas labeled with:
7 Comments (7 New)
Comments
Anonymous
Not applicable
‎07-03-2023 07:04 PM

Hi @bodxisatva 

What is the version of Desktop that you use for testing? Can you provide your pbix file(remove sensitive info) for testing ?

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

 

Best Regards,
Community Support Team _ Ailsa Tao

 

bodxisatva
Regular Visitor
‎07-04-2023 12:01 AM

Hi @Anonymous 

 

I checked this in two versions of PowerBI Desktop and it behaves the same:
- 2.118.828.0 64-bit (June 2023)

- 2.118.621.0 64-bit (June 2023)

This issue also happens with report when it's published to PowerBI web.

 

Since the report is pulling data from a OLAP cube it's not possible for me to share the pbix file at the moment.

 

Stan

bodxisatva
Regular Visitor
‎07-04-2023 02:55 AM

Hi @Anonymous,

I tried to reproduce this issue against testing OLAP cube based on AdventureDW and it works fine with it.

I will try to look further in our OLAP cubes' setup to see why it could be happening.

 

Stan

Anonymous
Not applicable
‎07-04-2023 06:25 PM

Hi @bodxisatva 

Hoping this is only an occasional problem. Looking forward to your reply!

 

Best Regards,
Community Support Team _ Ailsa Tao

bodxisatva
Regular Visitor
‎07-06-2023 02:56 AM

Hi @Anonymous 

 

I found the reason for such behaviour. If the dimension attribute used in hierarchy has value maintained with different source than a name for it, then it will be behaving in dropdown slicer like I described above.

- Here is the value that set to be using Code filed as a source

dimension_01.PNG

 

If the value for dimension attribute is not mainatained then it behaves normally:

dimension_03.PNG

 

Is this an expected behaviour of PowerBI?

We widely use an approach when Value differs from Name for attributes in dimensions and build a Hierarchies over those attributes. This already gives our buiseness certain discomfort and can do even more in future.

 

Stan

Stan

Anonymous
Not applicable
‎07-06-2023 06:25 PM

Hi @bodxisatva 

Based on the above information, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.

 

The link of Power BI Support: https://powerbi.microsoft.com/en-us/support/

For how to create a support ticket, please refer to https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

 

Best Regards,
Community Support Team _ Ailsa Tao

bodxisatva
Regular Visitor
‎07-10-2023 01:01 AM

@Anonymous 

 

Thank you, I opened a support ticket

 

Stan

Idea Statuses