Forum Discussion
Creating Hierarchy Slicers with Overlapping Groups
Anonymous , Create measures for those and then create a calculation group. That will convert set of measures into dimension
Power BI Model Explorer with calculation group authoring
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-the-model-explorer-with-calculation-group-authoring-and-creating-relationships-in-the-properties-pane/
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
Hi amitchandak Thanks for your responses.
Based on the instructions in your vidoes, I did create a measure based on a disconnected table of list of overlapping Years group categories. First, I created a Years Overlapping field in the data table based on the original Years (exclusive group) field. Then I created the measure using the search words function to search the year group included in the disconnected table of year groups list. I can used the measure as a filter=1 and the Years list field as a slicer. See screenshot below.
However, when I try to use the "Years List" field to replace the original (Exclusvie) Years field in the hierarchy slicer on the left, there is an error message: you are using fields that dont have a supported set of relationships. So I cannot use the measure in the hierarchy slicer. Althoug it can be used in a slicer by itself. That means, the Years slicer will apply to all selected categories, instead of different combinations. See Screenshot below:
Do you have any suggestions on this?
Thanks.
Lijun