This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 7.000000000000001%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
Hi All,,
I have a dimension and one of the attribute is hidden and in the filter expression when i make the selection it is not filtering . Please see the attached screen shot, it is displaying all attributes after Miami',Please need help.
Thanks
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
Hi @Comanchi ,
Welcome to Microsoft Q&A!
The hidden levels are visible in the user-defined hierarchy. For more information, please refer to Hiding and Disabling Attribute Hierarchies.
Best regards,
Carrin
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
@CarrinWu-MSFT
Thanks the issue is I have 4 levels Enterprise>Entity>Unit>Provider
In the Browser when i select the hierarchy and select Enterprise=Miami and Entity as 'XXX' it only filters by the first attribute and displays all the members of the second attribute "entity" and not just 'XXX' , but when i uncheck 'Miami' and filter at the second attribute (Entity) it shows only 'XXX'. Hope i am clear. Please help.
Thanks