hierarchy slicer
6 TopicsDynamic title for hierarchy slicer: How to always show lowest selected level
Hi there, I have a report that has KPIs structured into two columns, who are hierarchical - "Task" and "CoreTask". Each CoreTask has at least one, some multiple tasks. I solved the selection with a hierarchy slicer: CoreTask as Level 1 -> Task as Level 2 What I would like to do is have a dynamic header that always shows the lowest level selection - if a CoreTask and no Task is selected show CoreTask title; if a Task to a CoreTask is selected, only show Task title. The selection setting is single-selection. If a CoreTask is selected with no Task selected, it automatically selects all Tasks (could this be an issue?) I have tried with the following DAX but I cannot get the title, except the prefix "active: " to show up. I would really appreciate if you could help me out here. SlicerSelectionTitle = IF( ISFILTERED('Finances'[Task]), "active: " & SELECTEDVALUE('Finances'[Task]), IF( ISFILTERED('Finances'[CoreTask]), "active: " & SELECTEDVALUE('Finances'[CoreTask]) ) ) Dynamic Header based on Hierarchical Slicer Selection in Power BI | BI Consulting Pro | Power BI |4K (youtube.com) <- my resource for writing the DAX aboveSolved933Views0likes2CommentsHierarchy Slicer Blanks
Hello Everyone, I have an issue with Hierarchy slicer visual. I used the visual to filter data based on Main Category and sub-category fields. The Main Category is on one table but the sub-categories are in defferent tables. The issue is when I draged- droped the sub-categories to the slicer, I have to brows many blanks levels to reach to child level. The below image illustrates the issue. Please advice thank you :)4.5KViews0likes4CommentsHierarchy Slicer visual not working after on Bookmark
Hi Team, I have 25 different categories in Hierarchy Slicer visual and using bookmark applied on button, i am selecting 5 categories as default. Here If my all categories are already selected then my default button will not behaving correctly. My data get filtered on those 5 categories but Hierarchy Slicer visual showing all categories selected. And when I deselect any one category and after if i click on default button then its showing my default selection.480Views0likes0CommentsHierarchy Slicer visual not working after September 2019 update
Hi Team, We hae quiet a number of Hierarchy Slicers in our Power bi report server dashboard which are not working after updating the power bi report server to September 2019 release. When i try to select the options in the power bi report server the filters are not applying.Solved12KViews4likes16CommentsDAX measure to group weeks together
I am working with data from a higher education data source and I am having trouble figuring out how to group items. For example, our modules last 4 weeks. I am trying to group Week 1 discussions, Week 1 assignments, and Week 1 assessments into a group so an average can be calculated. I am having trouble because I have old naming standards and items that are named something unique for that class. I am just not sure how I can standardize the names to make them filterable. I don't know if I should be using a hierarchy, a filtering DAX measure, or something altogether different. Any help would be appreciated.917Views0likes1Comment