bodxisatva
3 years agoRegular Visitor
Status:
Investigating
Dropdown slicer malfunction when used for OLAP cube hierarchy fields
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 th...
bodxisatva
3 years agoRegular Visitor
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
If the value for dimension attribute is not mainatained then it behaves normally:
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