Forum Discussion
Issue with Custom Visual (Hierarchy slicer) in Power Bi Report
Hi Team,
I have a report that includes multiple slicers configured as follows:
- Page-level slicers – Using the built-in Slicer visual, which includes: Program, Category, Subcategory, and Status….
- Button slicer – Used for Status (e.g., Total, On Track, Off Track, etc.). This interacts with all visuals except the page-level slicers. Even when there is no data, it displays all statuses at the top. Since we needed to include the Total option, a new table was created, and the Status column is being fetched from that table.
- Hierarchy slicer (Custom Visual) – Placed below the button slicer. This interacts with all visuals except the button slicer and the main built-in slicers.
Issue:
The button slicer shows all statuses regardless of data availability. When a status with no corresponding data is selected, the hierarchy slicer still displays values — seemingly related to previous selected status data — despite visual-level flags or DAX measures being applied.
Notably, when switching the hierarchy slicer to Focus Mode or viewing it as a table, it correctly shows blank results. However, once clicking the button slicer again, the hierarchy slicer reverts to showing incorrect data.
Question:
How can we refresh the custom visual or clear its cache to ensure that the data refreshes properly and displays accurate Data as per button slicer?
Regards,
Pave
Hi Pave ,
Thanks for reaching out to the Microsoft fabric community forum.Since the Hierarchy Slicer is a custom visual, it might not refresh or react to DAX filters and visual-level flags the same way as built-in visuals. That’s likely why it still shows values even when no data exists.
You can try the following:
- Check if the relationship direction allows filters to flow between the tables (try bidirectional if possible).
- Create a small dependency or disconnected measure in your DAX to force a refresh when the button slicer changes.
Best Regards,
Community Support Team
5 Replies
- danextian
Super User
Hi Pave
Does a relationship directly flow from the column used in the hierarchy slicer to the one in the button slicer. If it isn't then that is an expected behaviour. You can try visually filtering the button slicer by a measure that responds to the selection in the hierarchy slicer - use is not blank.
Hi danextian ,
Thank you for your time!
Actually there is a many-to-many relationship with single-directional was creted between the two tables.
The Status column utilized in the Hierarchy Slicer DAX expressions is related to the Status column in button slicer table.
i have used the Slicer column in Button slicer as i want "Total" option as well in report.I have created a flag measure and applied it as a visual-level filter to hide items when no data is available. This approach is working as expected for all other built-in visuals. However, it is not functioning correctly for the Hierarchy Slicer (custom visual), which continues to display values even when there is no corresponding data.
v-menakakotaCommunity Support
Hi Pave ,
Thanks for reaching out to the Microsoft fabric community forum.Since the Hierarchy Slicer is a custom visual, it might not refresh or react to DAX filters and visual-level flags the same way as built-in visuals. That’s likely why it still shows values even when no data exists.
You can try the following:
- Check if the relationship direction allows filters to flow between the tables (try bidirectional if possible).
- Create a small dependency or disconnected measure in your DAX to force a refresh when the button slicer changes.
Best Regards,
Community Support Team
