Forum Discussion
Dynamic hierarchy based on user login in a matrix visual
Hi Charan77
Do this:
Create a table with a column containing the distinct values of both L1 and L5 using either DAX or M.
Create relationships between that table and the original Dim table - an active relationshipo to L1 and an inactive to L5 or the other way around.
Use the column from this table in matrix as L1 and the other columns from the original table.
Create a measure that checks whether the user is in the list to be restricted and whether the column in the second-level hierarchy is currently inscope. Invoike the inactive relationship with USERELATIONSHIP if the above conditions are true else return a the base measure/aggregation.
Note: the boldness of the category font cannot be controlled with DAX (currently).
Please see the attached pbix.
Could you please help on hierarchy issue with different approach. There is one column called attribute and i need hierarchy on this column based on two different columns. Total 20 distinct attributes present in attribute column. Out of 20 attributes for 16 attributes required drill/hierarchy info based on one column and 4 attribute based on other column with condition that if we expanding 16 attributes then there should not be blank value in other 4 attributes or no entry in those and vice versa for other 4 attributes.